import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
public class MysqlDemo {
public static void main(String[] args) throws Exception {
Connection conn = null;
String sql;
// MySQLçJDBC URLç¼åæ¹å¼ï¼jdbc:mysql://主æºå称ï¼è¿æ¥ç«¯å£/æ°æ®åºçå称?åæ°=å¼
// é¿å
ä¸æä¹±ç è¦æå®useUnicodeåcharacterEncoding
// æ§è¡æ°æ®åºæä½ä¹åè¦å¨æ°æ®åºç®¡çç³»ç»ä¸å建ä¸ä¸ªæ°æ®åºï¼ååèªå·±å®ï¼
// ä¸é¢è¯å¥ä¹åå°±è¦å
å建javademoæ°æ®åº
String url = "jdbc:mysql://localhost:3306/javademo?"
+ "user=root&password=root&useUnicode=true&characterEncoding=UTF8";
try {
// ä¹æ以è¦ä½¿ç¨ä¸é¢è¿æ¡è¯å¥ï¼æ¯å 为è¦ä½¿ç¨MySQLç驱å¨ï¼æ以æ们è¦æå®é©±å¨èµ·æ¥ï¼
// å¯ä»¥éè¿Class.forNameæå®å è½½è¿å»ï¼ä¹å¯ä»¥éè¿åå§åæ¥é©±å¨èµ·æ¥ï¼ä¸é¢ä¸ç§å½¢å¼é½å¯ä»¥
Class.forName("com.mysql.jdbc.Driver");// å¨æå è½½mysql驱å¨
// or:
// com.mysql.jdbc.Driver driver = new com.mysql.jdbc.Driver();
// orï¼
// new com.mysql.jdbc.Driver();
System.out.println("æåå è½½MySQL驱å¨ç¨åº");
// ä¸ä¸ªConnection代表ä¸ä¸ªæ°æ®åºè¿æ¥
conn = DriverManager.getConnection(url);
// Statementéé¢å¸¦æå¾å¤æ¹æ³ï¼æ¯å¦executeUpdateå¯ä»¥å®ç°æå
¥ï¼æ´æ°åå é¤ç
Statement stmt = conn.createStatement();
sql = "create table student(NO char(20),name varchar(20),primary key(NO))";
int result = stmt.executeUpdate(sql);// executeUpdateè¯å¥ä¼è¿åä¸ä¸ªåå½±åçè¡æ°ï¼å¦æè¿å-1就没ææå
if (result != -1) {
System.out.println("å建æ°æ®è¡¨æå");
sql = "insert into student(NO,name) values('2012001','é¶ä¼åº')";
result = stmt.executeUpdate(sql);
sql = "insert into student(NO,name) values('2012002','å¨å°ä¿')";
result = stmt.executeUpdate(sql);
sql = "select * from student";
ResultSet rs = stmt.executeQuery(sql);// executeQueryä¼è¿åç»æçéåï¼å¦åè¿å空å¼
System.out.println("å¦å·\tå§å");
while (rs.next()) {
System.out
.println(rs.getString(1) + "\t" + rs.getString(2));// å
¥å¦æè¿åçæ¯intç±»åå¯ä»¥ç¨getInt()
}
}
} catch (SQLException e) {
System.out.println("MySQLæä½é误");
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
} finally {
conn.close();
}
}
}
追é®ä»£ç æç¥éï¼è¯·é®è¿äºä»£ç åºè¯¥å¤å¶å°åªéï¼
追çä½ å¨åªéè¦è¿æ¥æ°æ®åºå°±æ¾å¨åªé