JDBCæä½MySQLæ°æ®åºçæ¥éª¤
1ãåå¤MySQLæ°æ®åºé©±å¨å
ï¼mysql-connector-java-5.0.8-bin.jarï¼ä¸ä¸ªé¡¹ç®ä¸åªè½åå¨ä¸ä¸ªçæ¬ç驱å¨å
aãå¤å¶è¯¥é©±å¨å
ï¼ç²è´´å°é¡¹ç®ä¸
bãéä¸é¡¹ç®éç驱å¨å
ï¼å³é®->Build Path->Add to Build Path
2ãå¨ç±»éå代ç å 载驱ï¼å³å®è¿æ¥åªç§æ°æ®åº
aãClass.forName("com.mysql.jdbc.Driver");
bãå¿
é¡»è¿è¡å¼å¸¸å¤çï¼ClassNotFoundException
3ãè¿æ¥æ°æ®åº
aãConnection con=DriverManager.getConnection("è¿æ¥å符串", "ç¨æ·å", "å¯ç ");
bãè¿æ¥åç¬¦ä¸²æ ¼å¼åºå®ï¼ä¸åæ°æ®åºï¼æ ¼å¼ä¸åï¼jdbc:mysql://è¦è¿æ¥ç计ç®æºå称:端å£å·/è¦è¿æ¥çæ°æ®åºå称
cãå¿
é¡»è¿è¡å¼å¸¸å¤çï¼SQLException
4ãæ¼åè¦æ§è¡çsqlè¯å¥ï¼å¿
é¡»æ¯å¯ä»¥å¨æ°æ®åºä¸æ§è¡ç
5ãå建æ§è¡sqlè¯å¥ç对象
aãStatement stmt=con.createStatement();
bã注æï¼Statementå¿
é¡»æ¥èªäºjava.sqlå
ä¸
6ãæ§è¡sqlè¯å¥
aãæ§è¡insertãupdateådeleteè¯å¥ï¼int row=stmt.executeUpdate(sql);è¿åå½±åè¡æ°
bãæ§è¡æ¥è¯¢è¯å¥ï¼ResultSet rs=stmt.executeQuery(sql);è¿åæ¥è¯¢ç»æ
cãæ§è¡ä»»æsqlè¯å¥ï¼DDLãDCLãDMLåDQLçï¼
7ã对æ§è¡ç»æè¿è¡å¤ç
aãæ§è¡æ´æ°è¯å¥ï¼å¤æå½±åè¡æ°æ¯å¦ä¸º0,0表示失败ï¼é0表示æå
bã对æ¥è¯¢ç»æè¿è¡å¤çï¼
1) ç»æééè¦å
移å¨ãååå¼ ï¼rs.next();int id=rs.getInt(1);
String name=rs.getString("loginName");
2) ç»æéæå¤æ¡æ¶ï¼éè¦å¾ªç¯æä½ï¼
while(rs.next()){ System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getInt(5));
}
3) ä¸ç¡®å®æ¯å¦ææ¥è¯¢ç»ææ¶ï¼if(rs.next()){说æææ¥è¯¢ç»æ}else{没ææ¥è¯¢ç»æ}
4) 使ç¨äºèåå½æ°ï¼ä¸å®ææ¥è¯¢ç»æï¼æ¥è¯¢ç»ææ¯ä¸è¡ä¸åï¼
rs.next();
int result=rs.getInt(1);
注æï¼ç»æéåå¼æ¶ååºçæ¶æ¥è¯¢è¯å¥ä¸å
å«çå段ï¼ä¸è¡¨ä¸å段æ å
³
9ãå
³éç¸å
³å¯¹è±¡ï¼å
å
³éç»æé对象ãå¨å
³éæ§è¡è¯å¥å¯¹è±¡ï¼æåå
³éè¿æ¥å¯¹è±¡ï¼
ä¾å¦ï¼æ§è¡æ¥è¯¢è¯å¥
Scanner input=new Scanner(System.in);
System.out.print("请è¾å
¥ç»å½åï¼ ");
String name=input.next();
System.out.print("请è¾å
¥å¯ç ï¼ ");
String pass=input.next();
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/userdb", "root", "root");
String sql="select COUNT(*) from UserInfo where loginName='"+name+"' and loginPass='"+pass+"'";
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sql);
rs.next();
int result=rs.getInt(1);
if(result!=0){
System.out.println("ç»å½æåï¼");
}else{
System.out.println("ç¨æ·åæå¯ç é误ï¼è¯·éæ°ç»å½ï¼");
}
rs.close();
stmt.close();
con.close();
} catch (ClassNotFoundException e) {
System.out.println("å 载驱å¨é误ï¼"+e.getMessage());
} catch (SQLException e) {
System.out.println("æ°æ®åºæä½é误ï¼"+e.getMessage());
}
æ§è¡æ·»å ãä¿®æ¹åå é¤è¯å¥
try {
//å 载驱å¨
Class.forName("com.mysql.jdbc.Driver");
//è¿æ¥æ°æ®åº
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/userdb", "root", "root");
//æ¼åè¦æ§è¡çsqlè¯å¥
String sql="update UserInfo set loginPass='111' where loginName='a'";
//String sql="insert UserInfo values(default,'test','test')";
//String sql="delete from UserInfo where loginName='a'";
//å建æ§è¡è¯å¥å¯¹è±¡
Statement stmt=con.createStatement();
//æ§è¡
int row=stmt.executeUpdate(sql);
//å¤çç»æ
if(row==0){
System.out.println("ä¿®æ¹å¤±è´¥ï¼");
}else{
System.out.println("ä¿®æ¹æåï¼");
}
//å
³é
stmt.close();
con.close();
} catch (ClassNotFoundException e) {
System.out.println("驱å¨å è½½é误ï¼"+e.getMessage());
} catch (SQLException e) {
System.out.println("æ°æ®åºæä½é误ï¼"+e.getMessage());
}
温馨提示:答案为网友推荐,仅供参考