package common;
import java.sql.*;
public class DBManager {
private String myDriver=null;
private String myConnStr=null;
private Connection myConn=null;
private Statement myStmt=null;
private ResultSet myResults=null;
public DBManager(){ //加载mysql驱动
String DBDRIVER = "org.gjt.mm.mysql.Driver" ;
String DBURL = "jdbc:mysql://127.0.0.1/school?useUnicode=true&characterEncoding=GBK";
String DBUSER = "root" ;
String DBPASSWORD = "root" ;
try{
Class.forName(DBDRIVER);
}catch(ClassNotFoundException e){
System.out.println("加载mysql驱动"+e.getMessage());
}
}
public boolean execInsert(String insertString){ //数据添加
try{
myConn=DriverManager.getConnection(myConnStr);
myStmt=myConn.createStatement();
myStmt.executeUpdate(insertString);
} catch(SQLException e){
System.out.println("添加数据"+e.getMessage());
return false;
}
return true;
}
public ResultSet execQuery(String queryString){ //数据查询
try{
myConn=DriverManager.getConnection(myConnStr);
myStmt=myConn.createStatement();
myResults=myStmt.executeQuery(queryString);
} catch(SQLException ex){
System.out.println("查询数据"+ex.getMessage());
}
return myResults;
}
public boolean execUpdata(String updataString){ //数据更新
try{
myConn=DriverManager.getConnection(myConnStr);
myStmt=myConn.createStatement();
myStmt.executeUpdate(updataString);
myStmt.close();
myConn.close();
} catch(SQLException ex){
System.out.println("更新数据"+ex.getMessage());
return false;
}
return false;
}
public void execDelect(String deleteString){ //删除数据
try{
myConn=DriverManager.getConnection(myConnStr);
myStmt=myConn.createStatement();
myStmt.executeUpdate(deleteString); //executeDelect
myStmt.close();
myConn.close();
} catch(SQLException ex){
System.out.println("删除数据"+ex.getMessage());
}
}
public void closeManager(){ //关闭创建对象
try{
myStmt.close();
myConn.close();
} catch(SQLException ex){
ex.printStackTrace();
}
}
public void closeStatement(){
try{
myStmt.close();
} catch(SQLException ex){
ex.printStackTrace();
}
}
public void closeConnection(){
try{
myConn.close();
} catch(SQLException ex){
ex.printStackTrace();
}
}
}