Jsp+JavaBean+Servlet(绝对正确)

package com; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import com.Student; public class Datebase { public static Connection getConnection() { Connection con = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=stu", "sa","123"); } catch (Exception e) { e.printStackTrace(); } return con; } public String getCharset(String str) { String newStr = ""; try { newStr = new String(str.getBytes("ISO-8859-1"), "GB2312"); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } return newStr; } public int insert( Student sdb) { //ArrayList list=new ArrayList(); int b=0; Connection con = getConnection(); try{ String Id=sdb.getId(); String name=sdb.getName(); String password=sdb.getPassword(); String sex=sdb.getSex(); String birthday=sdb.getBirthday(); String working=sdb.getWorking(); String phone=sdb.getPhone(); String post=sdb.getPost(); Statement st=con.createStatement(); st.executeUpdate("insert into stuinfo values('"+Id+"','"+name+"','"+password+"','"+sex+"','"+birthday+"','"+working+"','"+phone+"','"+post+"')"); // list=select1(); st.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); } return b; } public ArrayList<Student> select1(){ Connection con=null; ResultSet rs=null; Statement st =null; ArrayList<Student> list = new ArrayList<Student>(); String Id,name,password,sex,birthday,working,phone,post; con = Datebase.getConnection(); try { st = con.createStatement(); rs = st.executeQuery("select * from stuinfo "); while (rs.next()) { Id = rs.getString("Id") + ""; name = (rs.getString("name")); password = rs.getString("password") + ""; sex = rs.getString("sex") + ""; birthday = (rs.getString("birthday")); working = (rs.getString("working")); phone = (rs.getString("phone")); post = (rs.getString("post")); Student std = new Student(); std.setId(Id); std.setName(name); std.setPassword(password); std.setSex(sex); std.setBirthday(birthday); std.setWorking(working); std.setPhone(phone); std.setPost(post); list.add(std); } //st.close(); //rs.close(); } catch (SQLException e) { e.printStackTrace(); } return list; } public Student select(String cr) { //ArrayList list = new ArrayList(); String Id,name,password,sex,birthday,working,phone,post; Student std = new Student(); Connection con = Datebase.getConnection(); ResultSet rs=null; try { Statement st = con.createStatement(); rs = st.executeQuery("select * from stuinfo where name='"+cr+"'"); if (rs.next()) { Id = rs.getString("Id") + ""; name = (rs.getString("name")); password = (rs.getString("password")); sex = rs.getString("sex") + ""; birthday = (rs.getString("birthday")); working = (rs.getString("working")); phone = (rs.getString("phone")); post = (rs.getString("post")); //Student std = new Student(); std.setId(Id); std.setName(name); std.setPassword(password); std.setSex(sex); std.setBirthday(birthday); std.setWorking(working); std.setPhone(phone); std.setPost(post); //list.add(std); } st.close(); rs.close(); } catch (SQLException e) { e.printStackTrace(); } return std; } public ArrayList<Student> delete(String name1){ ArrayList<Student> list=new ArrayList<Student>(); Connection con=Datebase.getConnection(); try{ Statement st=con.createStatement(); st.executeUpdate("delete from stuinfo where name='"+name1+"'"); //=select1(); st.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); } return list; } private static Connection con; public static void update(Student sdb,String name1){ con=getConnection(); ResultSet rs=null; try{ Statement st=con.createStatement(); st.executeUpdate("update stuinfo set Id='"+sdb.getId()+"',name='"+sdb.getName()+"',password='"+sdb.getPassword()+"',sex='"+sdb.getSex()+"',birthday='"+sdb.getBirthday()+"',working='"+sdb.getWorking()+"' ,phone='"+sdb.getPhone()+"',post='"+sdb.getPost()+"' where name='"+name1+"'"); // sdb.select(); st.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); } } }