jdbc 连接Mysql数据库

import java.sql.*;


public class LinkDb {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver"); // 数据库名
            //数据库名，用户名，密码
conn = DriverManager.getConnection(
"jdbc:mysql://localhost/linkmodel", "root", "root");
Statement stat = conn.createStatement();// 创建语句
String addData = "INSERT INTO student (stuname,stuNumber,stuSex)VALUES('Atlas','0032','m')";
String deleteData = "DELETE FROM student WHERE stuNumber='0032'";
String alterData = "UPDATE student SET stuSex='f' WHERE stuNumber='0032'";
String queryData = "SELECT *FROM student WHERE stuNumber='0032'";
stat.executeUpdate(addData);// 添加
System.out.println("添加成功！");
stat.executeQuery(queryData);
ResultSet rs = stat.executeQuery(queryData);
System.out.println("结果如下：");
while (rs.next()) {
String stuname = rs.getString("stuName");
String stunumber = rs.getString("stuNumber");
String stusex = rs.getString("stuSex");
System.out.println("name:" + stuname + "\number:" + stunumber
+ "\nsex:" + stusex);
}
rs.close();
stat.executeUpdate(alterData);
System.out.println("修改成功！");
System.out.println("结果如下：");
ResultSet rss = stat.executeQuery(queryData);// 查询数据库
while (rss.next()) {
String stuname = rss.getString("stuName");
String stunumber = rss.getString("stuNumber");
String stusex = rss.getString("stuSex");
System.out.println("name:" + stuname + "\number:" + stunumber
+ "\nsex:" + stusex);
}
rss.close();
try {
conn.setAutoCommit(false); // ！！！事务，设置不自动提交！！！
stat.executeUpdate(deleteData);
conn.commit();// 提交
System.out.println("提交事务完成！");
System.out.println("删除成功！");
} catch (Exception ex) {
conn.rollback();// 回滚
System.out.println(" 正在回滚事务！");
}
stat.close();
conn.close();// 本来应该ｆａｎｌｌｙ的　
} catch (Exception e) {
e.printStackTrace();
}


}
}