jdbc连接mysql

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

　　

jdbc连接mysql

标签：