public class ConnDB {
private Connection ct = null;
//驱动程序名
String driver = "com.mysql.jdbc.Driver";
// URL指向要访问的数据库名scutcs
String url = "jdbc:mysql://127.0.0.1:3306/develop";
// MySQL配置时的用户名
String user = "root";
// Java连接MySQL配置时的密码
String password = "wzy123";
public static Connection getConn(){
try{
Class.forName(driver);
ct = DriverManager.getConnection(url, user, password);
}
catch(Exception e){
e.printStackTrace();
}
return ct;
}
public int add(String day,String time,
String volname,String volclass,String voltel,String volemail){
Connection con = DbConnect.this.getConn();
int num = -1;
try {
java.sql.Statement statement = con.createStatement();
num = statement.executeUpdate( "insert into tb_volinfo(day,time,volname,volclass,voltel,volemail) "
+ "values('"+day+"','"+time+"','"+volname+"','"+volclass+"','"+voltel+"','"+volemail+"')");
if(statement!=null){
statement.close();
}
if(con!=null){
con.close();//关闭数据库连接
}
} catch (Exception e) {
e.printStackTrace();
}
return num;
}
public boolean SelectVal(String volname,String voltel){
Connection con1 = DbConnect.this.getConn();
ResultSet result =null;
try {
java.sql.Statement statement = con1.createStatement();
result = statement.executeQuery("select * from tb_volinfo where volname='"+volname+"' and voltel='"+voltel+"';");
while(result.next()){
return true;
}
if(statement!=null){
statement.close();
}
if(con1!=null){
con1.close();//关闭数据库连接
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
}