package javabean;
import java.sql.*;
import java.sql.ResultSet;
import java.sql.Statement;
/**
*
* @author Administrator
*/
public class DatabaseAccess {
private String drv = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://localhost:3306/jiang";
private String usr = "root";
private String pwd = "123456";
private Connection conn = null;
private Statement stm = null;
private ResultSet rs = null;
public DatabaseAccess(){
try{
Class.forName(drv);//加载数据库驱动程序
conn = DriverManager.getConnection(url, usr, pwd);//如果可以执行到这一行说明数据库连接成功
stm = conn.createStatement();
}catch(Exception e){
System.out.println(e.toString());
}
}
public boolean update(String sql){
boolean b=false;
try{
stm.executeUpdate(sql);
}catch(Exception e){
System.out.println(e.toString());
}
return b;
}
public ResultSet query(String sql)
{
try{
rs=stm.executeQuery(sql);
}catch(Exception e){
System.out.println(e.toString());
}
return rs;
}
public boolean isHaveResult(String sql)
{
boolean b=false;
try{
rs=stm.executeQuery(sql);
if(rs.next()) b=true;
}catch(Exception e){
System.out.println(e.toString());
}
return b;
}
public void close(){
try {
if (rs != null) {
rs.close();
}
if (stm != null) {
stm.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception ex) {
System.out.println();
}
}
}