?? mysqltest.java
字號:
import java.sql.*;
public class MySqlTest {
/**
* @param args
*/
public static void main(String args[])
{
String url = "jdbc:mysql://localhost:3306/jiaoxue";
String user ="root";//這里替換成你自已的數據庫用戶名
String password = "123456";//這里替換成你自已的數據庫用戶密碼
String sqlStr = "SELECT * FROM student";
try{ //這里的異常處理語句是必需的.否則不能通過編譯!
Class.forName("org.gjt.mm.mysql.Driver");
System.out.println( "類實例化成功!" );
Connection con = DriverManager.getConnection(url, user, password);
System.out.println( "創建連接對像成功!" );
Statement st = con.createStatement();
System.out.println( "創建Statement成功!" );
st.executeUpdate("insert into student values(30,'aa',26)");
System.out.println( "插入成功!" );
ResultSet rs = st.executeQuery( sqlStr );
System.out.println( "讀取成功!" );
//st.executeUpdate("delect from student where Sno=1");
// System.out.println( "刪除成功!" );
System.out.println( "----------------!" );
rs = st.executeQuery( sqlStr );
while(rs.next())
{
System.out.print(rs.getString("Sno") + " ");
System.out.print(rs.getString("name") + " ");
System.out.println(rs.getString("age") + " ");
}
rs.close();
st.close();
con.close();
}
catch(Exception err){
err.printStackTrace(System.out);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -