JDBCè¿æ¥æ°æ®åº
•å建ä¸ä¸ªä»¥JDBCè¿æ¥æ°æ®åºçç¨åºï¼å
å«7个æ¥éª¤ï¼
1ãå è½½JDBC驱å¨ç¨åºï¼
å¨è¿æ¥æ°æ®åºä¹åï¼é¦å
è¦å è½½æ³è¦è¿æ¥çæ°æ®åºç驱å¨å°JVMï¼Javaèææºï¼ï¼
è¿éè¿java.lang.Classç±»çéææ¹æ³forName(String className)å®ç°ã
ä¾å¦ï¼
try{
//å è½½MySqlç驱å¨ç±»
Class.forName("com.mysql.jdbc.Driver") ;
}catch(ClassNotFoundException e){
System.out.println("æ¾ä¸å°é©±å¨ç¨åºç±» ï¼å 载驱å¨å¤±è´¥ï¼");
e.printStackTrace() ;
}
æåå è½½åï¼ä¼å°Driverç±»çå®ä¾æ³¨åå°DriverManagerç±»ä¸ã
2ãæä¾JDBCè¿æ¥çURL
•è¿æ¥URLå®ä¹äºè¿æ¥æ°æ®åºæ¶çåè®®ãååè®®ãæ°æ®æºæ è¯ã
•ä¹¦åå½¢å¼ï¼åè®®ï¼ååè®®ï¼æ°æ®æºæ è¯
åè®®ï¼å¨JDBCä¸æ»æ¯ä»¥jdbcå¼å§
ååè®®ï¼æ¯æ¡¥è¿æ¥ç驱å¨ç¨åºææ¯æ°æ®åºç®¡çç³»ç»å称ã
æ°æ®æºæ è¯ï¼æ è®°æ¾å°æ°æ®åºæ¥æºçå°åä¸è¿æ¥ç«¯å£ã
ä¾å¦ï¼ï¼MySqlçè¿æ¥URLï¼
jdbc:mysql:
//localhost:3306/test?useUnicode=true&characterEncoding=gbk ;
useUnicode=trueï¼è¡¨ç¤ºä½¿ç¨Unicodeå符éãå¦æcharacterEncoding设置为
gb2312æGBKï¼æ¬åæ°å¿
须设置为true ãcharacterEncoding=gbkï¼å符ç¼ç æ¹å¼ã
3ãå建æ°æ®åºçè¿æ¥
•è¦è¿æ¥æ°æ®åºï¼éè¦åjava.sql.DriverManager请æ±å¹¶è·å¾Connection对象ï¼
该对象就代表ä¸ä¸ªæ°æ®åºçè¿æ¥ã
•ä½¿ç¨DriverManagerçgetConnectin(String url , String username ,
String password )æ¹æ³ä¼ å
¥æå®ç欲è¿æ¥çæ°æ®åºçè·¯å¾ãæ°æ®åºçç¨æ·åå
å¯ç æ¥è·å¾ã
ä¾å¦ï¼
//è¿æ¥MySqlæ°æ®åºï¼ç¨æ·ååå¯ç é½æ¯root
String url = "jdbc:mysql://localhost:3306/test" ;
String username = "root" ;
String password = "root" ;
try{
Connection con =
DriverManager.getConnection(url , username , password ) ;
}catch(SQLException se){
System.out.println("æ°æ®åºè¿æ¥å¤±è´¥ï¼");
se.printStackTrace() ;
}
4ãå建ä¸ä¸ªStatement
•è¦æ§è¡SQLè¯å¥ï¼å¿
é¡»è·å¾java.sql.Statementå®ä¾ï¼Statementå®ä¾å为以ä¸3
ç§ç±»åï¼
1ãæ§è¡éæSQLè¯å¥ãé常éè¿Statementå®ä¾å®ç°ã
2ãæ§è¡å¨æSQLè¯å¥ãé常éè¿PreparedStatementå®ä¾å®ç°ã
3ãæ§è¡æ°æ®åºåå¨è¿ç¨ãé常éè¿CallableStatementå®ä¾å®ç°ã
å
·ä½çå®ç°æ¹å¼ï¼
Statement stmt = con.createStatement() ;
PreparedStatement pstmt = con.prepareStatement(sql) ;
CallableStatement cstmt =
con.prepareCall("{CALL demoSp(? , ?)}") ;
温馨提示:答案为网友推荐,仅供参考