class1-students.rar

package class1.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import class1.javaBean.Student; public class DaoFromDB implements Dao { String diverName = "com.mysql.jdbc.Driver";//驱动 String url = "jdbc:mysql://127.0.0.1/user?user=root&password=&characterEncoding=utf-8"; Connection con; Statement st; PreparedStatement pst; ResultSet rs; boolean flag; public DaoFromDB() { // TODO Auto-generated constructor stub try { Class.forName(diverName);//加载驱动 con = DriverManager.getConnection(url); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public boolean login(String name, String password) { // TODO Auto-generated method stub try { pst = con.prepareStatement("select * from user where name = ? and password=?"); pst.setString(1, name); pst.setString(2, password); rs = pst.executeQuery(); if(rs.next()){ flag = true; }else { flag =false; } close(con, null, pst, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); flag =false; } return flag; } public ArrayList<Student> display() { // TODO Auto-generated method stub ArrayList<Student> students = new ArrayList<Student>(); try { st = con.createStatement(); rs = st.executeQuery("select*from student"); while(rs.next()){ Student student = new Student(); student.setId(rs.getString("id")); student.setName(rs.getString("name")); student.setAge(rs.getString("age")); student.setTel(rs.getString("tel")); student.setAddress(rs.getString("address")); students.add(student); } close(con, st, null, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return students; } public void close(Connection con, Statement st, PreparedStatement ps, ResultSet rs) throws SQLException { // TODO Auto-generated method stub if(rs!=null&&rs.isClosed()){ rs.close(); } if(ps!=null&&ps.isClosed()){ ps.close(); } if(st!=null&&st.isClosed()){ st.close(); } if(con!=null&&con.isClosed()){ con.close(); } } public boolean insert(String id, String name, String age, String tel, String address) { try { pst = con.prepareStatement("insert into student values(?,?,?,?,?)"); pst.setString(1, id); pst.setString(2, name); pst.setString(3, age); pst.setString(4, tel); pst.setString(5, address); int temp = pst.executeUpdate(); if(temp!=0){ flag = true; }else { flag = false; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } }