import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/**
*jdbc快速入门
*/
public class JDBCDemo {
public static void main(String[] args) throws Exception {
// 1.注册
Class.forName("com.mysql.jdbc.Driver");
// 2.获取连接
String url = "jdbc:mysql://127.0.0.1:3306/DB1";
String username = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url, username, password);
// 3.sql
String sql = "update emp set gender = '女' where name = '张三'";
// 4.获取sql执行对象Statement
Statement stmt = conn.createStatement();
// 5.执行sql
int i = stmt.executeUpdate(sql);
System.out.println(i);
// 6.释放资源
stmt.close();
conn.close();
}
}
JDBC快速连接
最新推荐文章于 2024-07-22 14:15:06 发布