?? linkmysqlbyjdbc.java
字號:
import java.sql.*;
class linkMysqlByJDBC {
public static void main(String[] args){
try{
String driver = "org.gjt.mm.mysql.Driver"; //驅動類
String url = "jdbc:mysql://localhost:3306/MyFirstDB";
//連接字符串 其中TestDB是數(shù)據(jù)庫名
String username = "yrw"; //用戶名
String password = "870613"; //密碼
Connection con = null;
Statement sm = null;
ResultSet rs = null;
//////Step1//////////
Class.forName(driver);
//////Step2//////////
con = DriverManager.getConnection(url, username, password);
//////Step3//////////
String sql = "insert into s values('1223')";
sm = con.createStatement();
sm.execute(sql);
String sql2 = "select * from s";
rs = sm.executeQuery(sql2);
while (rs.next()) {
System.out.println(rs.getString("Name"));
}
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -