package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javabean.person;
public class udao {
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
public udao()//获得链接方法
{
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=data";
try {
con=DriverManager.getConnection(url, "sa", "sa");
} catch (SQLException e) {
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public void closeConnection()//关闭链接释放资源的方法
{
if(rs!=null)
{
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(ps!=null)
{
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(con!=null)
{
try {
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public ArrayList<person> getall() {
ArrayList<person> a = new ArrayList<person>();
String sql = "select * from person";
try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
person p = new person();
p.setId(rs.getInt("ID"));
p.setName(rs.getString("name"));
p.setAge(rs.getInt("age"));
p.setSex(rs.getString("sex"));
a.add(p);
}
} catch (SQLException e) {
e.printStackTrace();
}
return a;
}
public int add(person p)
{
int n=0;
String sql="insert into person values('"+p.getName()+"','"+p.getSex()+"',"+p.getAge()+")";
try {
ps=con.prepareStatement(sql);
n=ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return n;
}
public int del(int id)
{
int n=0;
String sql="delete from person where ID="+id+"";
try {
ps=con.prepareStatement(sql);
n=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return n;
}
public int update(person p,int id)
{
int m=0;
String sql="update person set name='"+p.getName()+"', sex='"+p.getSex()+"',age="+p.getAge()+" where id="+id+"";
try {
ps=con.prepareStatement(sql);
m=ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return m;
}
public ArrayList<person> getone(int id)
{
ArrayList<person> a=new ArrayList<person>();
String sql="select * from person where id="+id+"";
try {
ps=con.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next())
{
person p=new person();
p.setName(rs.getString("name"));
p.setAge(rs.getInt("age"));
p.setSex(rs.getString("sex"));
p.setId(rs.getInt("id"));
a.add(p);
}
} catch (SQLException e) {
e.printStackTrace();
}
return a;
}
}
Web.rar （43个子文件） 
Web 
.project 1KB .mymetadata 282B WebRoot WEB-INF fmt-1_0.tld 12KB fmt.tld 19KB sql-1_0-rt.tld 5KB fmt-1_0-rt.tld 11KB permittedTaglibs.tld 1KB web.xml 2KB scriptfree.tld 2KB c-1_0-rt.tld 11KB c-1_0.tld 11KB x-1_0-rt.tld 7KB x.tld 12KB sql.tld 8KB lib 
jstl.jar 20KB msbase.jar 278KB mssqlserver.jar 63KB msutil.jar 58KB standard.jar 384KB classes javabean person.class 1KB dao udao.class 4KB servlet list.class 1KB getone.class 2KB add.class 2KB del.class 2KB update.class 2KB sql-1_0.tld 6KB c.tld 16KB fn.tld 7KB x-1_0.tld 7KB 2.jsp 2KB 4.jsp 1KB META-INF MANIFEST.MF 39B 3.jsp 1KB 1.jsp 880B .myeclipse src javabean person.java 698B dao udao.java 3KB servlet list.java 899B update.java 1KB del.java 1KB add.java 1KB getone.java 994B .classpath 690B
- 1
- 2
前往页