java 登录库_java登录以及连接数据库的温习

packagecom.dao;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.ArrayList;importcom.bean.staff;importcom.db.DB;importcom.mysql.jdbc.Connection;importcom.mysql.jdbc.PreparedStatement;public classDao {//根据名称进行查询

@SuppressWarnings("static-access")public staticstaff selectName_staff(String staff_name) {

String tablename= "staff";

System.out.println("select staff where name = "+staff_name);

staff sta=null;

DB db=newDB();

Connection con=(Connection) db.getCon();try{

Statement stm=con.createStatement();

ResultSet rs= stm.executeQuery("select * from "+tablename+" where name='" + staff_name + "'");if(rs.next())

{

sta= newstaff();

System.out.println("select the stu from mysql");

sta.setJobid(rs.getString("jobid"));

sta.setName(rs.getString("name"));

sta.setSex(rs.getString("sex"));

sta.setBirthday(rs.getString("birthday"));

sta.setDepartment(rs.getString("department"));

sta.setRole(rs.getString("role"));

sta.setPassword(rs.getString("password"));//bean.setValue2(Integer.parseInt(rs.getString("teacher")));//bean.setValue3(Boolean.parseBoolean(rs.getString("address")));

System.out.println("name of the stu is "+rs.getString("staff_name"));

}

db.close(rs,stm, con);

}catch(Exception e) {

e.printStackTrace();

}returnsta;

}//添加普通员工信息

@SuppressWarnings("static-access")public booleanadd_staff(staff staff) {

String tablename= "staff";//表名

DB db=newDB();

Connection con=(Connection) db.getCon();try{

String sql="insert into "+tablename+"(jobid,name,sex,birthday,department,role,password) values ('"+staff.getJobid()+"','"+staff.getName()+"','"+staff.getSex()+"','"+staff.getBirthday()+"','"+staff.getDepartment()+"','"+staff.getRole()+"','"+staff.getPassword()+"')";

Statement stm=con.createStatement();

System.out.println(sql);

stm.execute(sql);

db.close(stm, con);

}catch(Exception e) {

e.printStackTrace();

System.out.println("add false");return false;

}

System.out.println("add true");return true;

}//根据员工名字进行删除

@SuppressWarnings("static-access")public static booleandelete_staff(String name)

{//String tablename ="test";

DB db=newDB();

Connection con=(Connection) db.getCon();//Connection con=null;

PreparedStatement stm=null;try{

con=(Connection) DB.getCon();

String sql="delete from staff where name='"+name+"'";//String sql="delete from test where name='"+bean.getName()+"'";

System.out.println(sql);

stm=(PreparedStatement) con.prepareStatement(sql);

stm.executeUpdate();return true;

}catch(SQLException e)

{

e.printStackTrace();

}finally{

db.close(stm, con);

}return false;

}//根据员工名字进行修改

@SuppressWarnings("static-access")public booleanupdate_staff(staff stu) {

Connection con=null;

PreparedStatement stm=null;

String tablename="staff";

DB db=newDB();try{

con=(Connection) DB.getCon();//String sql="update "+tablename+" set teacher=?,classroom=? where name=?";

String sql="update "+tablename+" set jobid=?,sex=?,birthday=?,department=?,role=?,password=? where name=?";//String sql="update "+tablename+"set teacher=?,classroom=? where name=?";

stm=(PreparedStatement) con.prepareStatement(sql);//stm.setString(3,bean.getName());//stm.setString(1, bean.getTeacher());//stm.setString(2,bean.getClassroom());

stm.setString(1,stu.getJobid());

stm.setString(2,stu.getSex());

stm.setString(3,stu.getBirthday());

stm.setString(4,stu.getDepartment());

stm.setString(5,stu.getRole());

stm.setString(6,stu.getPassword());

stm.setString(6,stu.getName());

stm.executeUpdate();

}catch(SQLException e)

{

e.printStackTrace();return false;

}finally{

db.close(stm, con);return true;

}

}//浏览员工全部信息

@SuppressWarnings("static-access")public ArrayListselectList_staff(){

Connection con=null;

PreparedStatement stm=null;

ResultSet rs=null;

ArrayList listbean=new ArrayList();

String tablename="staff";

DB db=newDB();try{

con=(Connection) db.getCon();

String sql="select * from "+tablename;

stm=(PreparedStatement) con.prepareStatement(sql);

rs=stm.executeQuery();while(rs.next()){

String jobid=rs.getString("jobid");

String name=rs.getString("name");

String sex=rs.getString("sex");

String birthday=rs.getString("birthday");

String department=rs.getString("department");

String role=rs.getString("role");

String password=rs.getString("password");

staff stu=new staff(0,jobid,name,sex,birthday,department,role,password);

listbean.add(stu);

}

}catch(SQLException e)

{

e.printStackTrace();

}finally{

db.close(stm, con);

}returnlistbean;

}

}