public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
//第一步:加載MySQL的JDBC的驅(qū)動
Class.forName("com.mysql.jdbc.Driver");
//取得連接的url,能訪問MySQL數(shù)據(jù)庫的用戶名,密碼;數(shù)據(jù)庫名
String url = "jdbc:mysql://localhost:3306/2";
String user = "root";
String password = "19870714";
//第二步:創(chuàng)建與MySQL數(shù)據(jù)庫的連接類的實(shí)例
conn = DriverManager.getConnection(url, user, password);
//第三步:用conn創(chuàng)建Statement對象類實(shí)例 stmt
stmt = conn.createStatement();
String sql ="insert into student values(3,'jjuan','m')";
stmt.executeUpdate(sql);
} catch (ClassNotFoundException e){
//加載JDBC錯誤,所要用的驅(qū)動沒有找到
System.out.println("驅(qū)動加載錯誤");
}catch (SQLException ex){
//顯示數(shù)據(jù)庫連接錯誤或查詢錯誤
System.err.println("SQLException:"+ex.getMessage());
}finally {
try{
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
}catch(SQLException e) {
System.err.println("SQLException:"+e.getMessage());
}
}
}
本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點(diǎn)擊舉報。