å½ç¶ï¼é¦å
è¦å®è£
æJDK(ä¸è¬æ¯JDK1.5.X)ãç¶åå®è£
MySQLï¼è¿äºé½æ¯è¾ç®åï¼å
·ä½è¿ç¨å°±ä¸è¯´äºãé
置好è¿ä¸¤ä¸ªç¯å¢åï¼ä¸è½½JDBC
驱å¨mysql-connector-java-5.0.5.zipï¼è¿ä¸ªæ¯ææ°ççï¼ãç¶åå°å
¶è§£å缩å°ä»»ä¸ç®å½ãææ¯è§£åå°Dçï¼ç¶åå°å
¶ç®å½ä¸ç
mysql-connector-java-5.0.5-bin.jarå å°classpathéï¼
å
·ä½å¦ä¸ï¼âæççµèâ-> âå±æ§â -> âé«çº§â ->
âç¯å¢åéâï¼å¨ç³»ç»åéé£éç¼è¾classpathï¼å°D:\mysql-connector-java-5.0.5\mysql-
connector-java-5.0.5-bin.jarå å°æåï¼å¨å è¿ä¸ªå符串åè¦å â;âï¼ä»¥ä¸åä¸ä¸ªclasspathåºåå¼ãç¶åç¡®å®ã
ç¯å¢é
置好äºï¼å¾ç®åãç°å¨ï¼å
é
ç½®Javaè¿æ¥MySQLï¼è®¾å
¶ç¨æ·å为ârootâï¼å¯ç 为ârootâãå¨å½ä»¤è¡æç¨ä¸ä¸ªSQLçå端软件å建Databaseã
ææ¯ç¨SQLyogçå端软件æ¥å建Databaseçã
å
å建æ°æ®åºï¼
CREATE DATABASE SCUTCS;
æ¥çï¼å建表ï¼
CREATE TABLE STUDENT ( SNO CHAR(7) NOT NULL, SNAME VARCHAR(8) NOT NULL, SEX CHAR(2) NOT NULL, BDATE DATE NOT NULL, HEIGHT DEC(5,2) DEFAULT 000.00, PRIMARY KEY(SNO) );
ç¶åæå
¥æ°æ®ï¼å¯ä»¥ç¨SQLè¯å¥insert into <表å> values (value1, value2, ...);
ä¹å¯ä»¥ç¨SQLyogæ¥æä½
好äºï¼å建好äºã
ä¸é¢ï¼æ们æ¥ç¼å.javaæ件æ¥æ¼ç¤ºä¸ä¸å¦ä½è®¿é®Javaè¿æ¥MySQLæ°æ®åºã
import java.sql.*; public class JDBCTest { public static void main(String[] args){
驱å¨ç¨åºå
String driver = "com.mysql.jdbc.Driver";
// URLæåè¦è®¿é®çæ°æ®åºåscutcs
String url = "jdbc:mysql://127.0.0.1:3306/scutcs";
// MySQLé
ç½®æ¶çç¨æ·å
String user = "root";
// Javaè¿æ¥MySQLé
ç½®æ¶çå¯ç
String password = "root";
try {
// å 载驱å¨ç¨åº
Class.forName(driver);
// è¿ç»æ°æ®åº
Connection conn = DriverManager.getConnection(url, user, password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statementç¨æ¥æ§è¡SQLè¯å¥
Statement statement = conn.createStatement();
// è¦æ§è¡çSQLè¯å¥
String sql = "select * from student";
ç»æé
ResultSet rs = statement.executeQuery(sql); System.out.println("-----------------"); System.out.println("æ§è¡ç»æå¦ä¸æ示:"); System.out.println("-----------------"); System.out.println(" å¦å·" + "\t" + " å§å"); System.out.println("-----------------"); String name = null; while(rs.next()) {
éæ©snameè¿åæ°æ®
name = rs.getString("sname");
// é¦å
使ç¨ISO-8859-1å符éå°name解ç 为åèåºå并å°ç»æåå¨æ°çåèæ°ç»ä¸ã
// ç¶å使ç¨GB2312å符é解ç æå®çåèæ°ç»
name = new String(name.getBytes("ISO-8859-1"),"GB2312");
// è¾åºç»æ
System.out.println(rs.getString("sno") + "\t" + name); } rs.close(); conn.close(); } catch(ClassNotFoundException e) { System.out.println("Sorry,can`t find the Driver!"); e.printStackTrace(); } catch(SQLException e) { e.printStackTrace(); } catch(Exception e) { e.printStackTrace(); } } }
æ¥ä¸æ¥æ们è¿è¡ä¸ä¸çä¸ææï¼
D:\testjdbc>javac JDBCTest.java
D:\testjdbc>java JDBCTest
Succeeded connecting to the Database!
-----------------------
æ§è¡ç»æå¦ä¸æ示:
-----------------------
å¦å· å§å
-----------------------
0104421 å¨è¿è¡
0208123 çä¹å¹³
0209120 ç大å
0309119 æ ç»´
0309203 欧é³ç¾æ
å®äºã
温馨提示:答案为网友推荐,仅供参考