要导入相应的包
]
1 public class ConnDB { 2 private Connection ct = null; 3 //驱动程序名 4 String driver = "com.mysql.jdbc.Driver"; 5 // URL指向要访问的数据库名scutcs 6 String url = "jdbc:mysql://127.0.0.1:3306/develop"; 7 // MySQL配置时的用户名 8 String user = "root"; 9 // Java连接MySQL配置时的密码
10 String password = "wzy123";
11 12 public Connection getConn(){ 13 try{ 14 Class.forName(driver); 15 ct = DriverManager.getConnection(url, user, password); 16 } 17 catch(Exception e){ 18 e.printStackTrace(); 19 } 20 return ct; 21 } 22 }
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;
}
原文：http://www.cnblogs.com/wwzyy/p/4952768.html