jdbc 连接mysql 代码_JDBC连接数据库步骤及代码

1.加载数据库驱动

private static final String DRIVER = "com.mysql.jdbc.Driver";

Class.forName(DRIVER );

2.建立数据库连接

a.数据库连接所需的字段

private static final String URL= "jdbc:mysql://localhost:8080/db_test";

private static final String USENAME = "root";

private static final String PASSWORD = "root";

b.建立数据库连接

Connection conn = DriverManager.getConnection(URL,USENAME,PASSWORD);

3.创建一个statement

//查询id为1的用户名密码

int id = 1;

String sql = "SELECT username,password FROM user WHERE id=?";

PrepareStatement ps = conn.prepareStatement(sql);

ps.serObject(1,id);

4.执行sql语句

ResultSet rs = ps.executeQuery();

5.处理结果

while(rs.next()){

String username = rs.getString(1);

String password = rs.getString(2);

System.out.println("用户名：" + username);

System.out.println("密码：" + password);

}

6.关闭连接

//按照创建顺序相反顺序关闭

rs.close();

ps.close();

jdbc.close();