as连接mysql实现登录_java连接mysql示例

packagedao;importjava.sql.ResultSet;importjava.sql.SQLException;public classDemo {public DBHelper db = newDBHelper();public ResultSet rs = null;public static voidmain(String[] args){

Demo d= newDemo();//d.insertAdmin("xl", "xl");//d.delectName("xl");//d.updateName("xl", "123");

d.selectAll();

}/** 增加记录

* @name 账号

* @password 密码

* @return 成功与否

**/

public booleaninsertAdmin(String name, String password){

String sql= "insert into admin(name,password) values(?,?)";try{

db.st=db.conn.prepareStatement(sql);

db.st.setString(1, name);

db.st.setString(2, password);returndb.st.execute();

}catch(SQLException e) {

e.printStackTrace();

}return false;

}/** 查找所有记录

**/

public voidselectAll(){

String sql= "select * from admin";try{

db.st=db.conn.prepareStatement(sql);

rs=db.st.executeQuery();while(rs.next()){int id = rs.getInt(1);

String name= rs.getString(2);

String password= rs.getString(3);

System.out.println("id:"+id+" name:"+name+" password:"+password);

}

}catch(SQLException e) {

e.printStackTrace();

}

}/** 根据账号，删除信息

* @name 账号

* @return 成功与否

**/

public booleandelectName(String name){

String sql= "delete from admin where name = ?";try{

db.st=db.conn.prepareStatement(sql);

db.st.setString(1, name);returndb.st.execute();

}catch(SQLException e) {

e.printStackTrace();

}return false;

}/** 根据账号，修改密码

* @name 账号

* @password 要修改的密码

* @return 成功与否

**/

public intupdateName(String name,String password){

String sql= "update admin set password = ? where name = ?";try{

db.st=db.conn.prepareStatement(sql);

db.st.setString(1, password);

db.st.setString(2, name);returndb.st.executeUpdate();

}catch(SQLException e) {

e.printStackTrace();

}return 0;

}

}