数据库的连接和关闭
package com.util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection() throws SQLException, ClassNotFoundException {
Class.forName("com.mysql.jdbc.Driver");
//创建连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzsxy","root","123456");
return connection;
}
public static void closeAll(ResultSet resultSet, Statement statement,Connection connection) throws SQLException {
if(resultSet != null){
resultSet.close();
}
if (statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
}
简单的增删改查
1.查询
package com;
import com.util.DBUtil;
import java.sql.*;
public class Find {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection connection = DBUtil.getConnection();
//写sql语句
String sql = "select * from tb_user";
//获得statement对象
PreparedStatement statement =connection.prepareStatement(sql);
//执行sql得到的结果集
ResultSet resultSet = statement.executeQuery();
//处理结果集
while(resultSet.next()){
System.out.println(resultSet.getInt(1));
System.out.println(resultSet.getString(2));
System.out.println(resultSet.getString(3));
}
//关闭资源
DBUtil.closeAll(resultSet,statement,connection);
// System.out.println("123");
}
}
2.删除
package com;
import com.util.DBUtil;
import java.sql.*;
public class Delete {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection connection = DBUtil.getConnection();
// //加载驱动
// Class.forName("com.mysql.jdbc.Driver");
// //创建连接
// Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/wzsxy","root","123456");
//写sql语句
String sql = "DELETE from tb_user where id=2";
//获得statement对象
PreparedStatement statement =connection.prepareStatement(sql);
//执行sql得到的结果集
statement.executeUpdate();
//处理结果集
//关闭资源
DBUtil.closeAll(null,statement,connection);
// System.out.println("123");
}
}
3.增加
package com;
import com.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Add {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection connection = DBUtil.getConnection();
//写sql语句
String sql = "insert into tb_user(username,password) values('qmy','123')";
//获得statement对象
PreparedStatement statement =connection.prepareStatement(sql);
//执行sql得到的结果集
statement.executeUpdate();
//处理结果集
DBUtil.closeAll(null,statement,connection);
// System.out.println("123");
}
}
4.修改
package com;
import com.util.DBUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Update {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Connection connection = DBUtil.getConnection();
//写sql语句
String sql = "update tb_user set username='qmy123' where username='qmy'";
//获得statement对象
PreparedStatement statement =connection.prepareStatement(sql);
//执行sql得到的结果集
statement.executeUpdate();
//处理结果集
DBUtil.closeAll(null,statement,connection);
// System.out.println("123");
}
}
面试小技巧
如果问到java如何连入到数据库,可以回答:
1.创建连接
2.加载驱动
3.创建连接
4.写入sql语句
5.获得statement对象
6.执行sql得到的结果集
7.处理结果集
8.关闭资源