jdbc连接mysql

要导入相应的包]

 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;
		}