package com.jdbcDemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCDemo {
public static Connection getDataBaseConnection(){
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/demo?characterEncoding=utf-8";
String user = "root";
String password = "root";
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
//加载驱动程序
try {
Class.forName(driver);
System.out.println("驱动程序加载成功...");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//连接数据库
try {
conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed()){
System.out.println("数据库连接成功...");
}
} catch (SQLException e) {
System.out.println("数据库连接失败:"+ e.getMessage());
}
//查询
try {
stmt = conn.prepareStatement("SELECT * FROM demo where name = ?");
stmt.setString(1, "zhangsan");
rs = stmt.executeQuery();
while(rs.next()){
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println("-------------------");
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}finally {
try {
if(rs != null){
rs.close();
}
if (stmt != null) {
stmt.close();
}
if(conn != null){
conn.close();
}
System.out.println("数据库关闭成功...");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return conn;
}
public static void main(String [] args){
JDBCDemo.getDataBaseConnection();
}
}
Java jdbc连接mysql
最新推荐文章于 2023-07-13 11:33:21 发布