String url = "jdbc:mysql://localhost:3306/jdbc_db";
String user = "root";
String pwd = "root";
Connection conn = null;
Statement st = null;
try {
// 1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.连接数据库
conn = DriverManager.getConnection(url, user, pwd);
st = conn.createStatement();
// 3.创建语句
String sql = "insert into student(name,age) values('"
+ stu.getName() + "'," + stu.getAge() + ")";
//输出语句
System.out.println(sql);
// 4.执行语句
st.executeUpdate(sql);
// 5.释放资源
} catch (Exception e) {
e.printStackTrace();
} finally {
if (conn != null) {
try {
st.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (st != null) {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
JDBC java连接mysql数据库
最新推荐文章于 2024-07-13 18:10:19 发布