如何去实现java与数据库的连接
java与数据库的连接总体可以分为7步
- 首先导入驱动jar包
- 加载数据库驱动
- 创建并获取数据库连接对象 Connection
- 定义SQL语句
- 获取执行SQL语句的对象
- 执行SQL语句,接收返回结果
- 释放资源
详细看代码的注释
package mybatis_Test.com.rjxy.mybasit.test1;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Jdbc {
static Connection conn=null;
public Connection getConnection() throws SQLException {
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.print("mySQL的驱动");
String url="jdbc:mysql:///liveshop?useUnicode=true&characterEncoding=UTF-8";
String password="123456";
String username="root";
conn=DriverManager.getConnection(url, username, password);
System.out.println("与数据库连接");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public static <CreateMysql> void main(String[] arg) {
Jdbc mySQL=new Jdbc ();
PreparedStatement preparedStatement = null;
ResultSet resultSet= null;
try {
mySQL.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
String sql="select * from address where name = ?";
try {
preparedStatement = conn.prepareStatement(sql);
preparedStatement.setString(1,"myt");
resultSet = preparedStatement.executeQuery();
while(resultSet.next()) {
System.out.println(resultSet.getString("name"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
if(resultSet!=null) {
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
if(preparedStatement!=null) {
try {
preparedStatement.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if(conn!=null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}