Javaè¦è¿æ¥æ°æ®åºï¼é£ä¹é¦å ä½ å¿ é¡»å®è£ mysqlæ°æ®åºã
å®è£ 好mysqlä¹åï¼å®è£ JDKäºã
å®è£ 好JDKä¹åï¼å°±æ¯å®è£ Eclipseäºï¼è¦æ¯æJDKçæ¬ï¼Eclipseå®è£ çæ¶åä¼èªå¨å»æ¾JDKå®è£ ä½ç½®çï¼è§£åççEclipseï¼å°±è¦é ç½®eclipse.iniæ件äºï¼å°å¯¹åºçJDKé 置好ï¼è¿äºå·²ç»åå¤å°±ç»ªçæ¶åï¼å°±å°mysqlä¸å建æ°æ®åºå表ã
å å建æ°æ®åºï¼
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, ...);
ç¼å.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"; // 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);
while(rs.next()) // éæ©snameè¿åæ°æ® name = rs.getString("sname
// è¾åºç»æ 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();
} } }