package mainPac;
import java.sql.*;
public class DatabaseOperator {
private Connection con = null;
//构造方法
public DatabaseOperator(){
super();
connectDatabase();
}
//连接数据库
public void connectDatabase(){
try {
//1.加载驱动
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//2.得到连接
con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName = Java_Test", "sa", "123456");
System.out.println("数据库连接成功");
}
catch (Exception e){
e.printStackTrace();
}
}
public Connection getConnection(){
return con;
}
public void setConnection(Connection con){
this.con = con;
}
//查询数据,返回数据集
public void queryData(String sSql){
PreparedStatement ps = null;
ResultSet rs = null;
try {
//3.发送sql语句
ps =getConnection().prepareStatement(sSql);
//4.执行
rs = ps.executeQuery();
//循环取出雇员的名字,薪水,部门的编号
while(rs.next()) {
String name = rs.getString("Name");
String sex = rs.getString("Sex");
int age=rs.getInt("Age");
String nation = rs.getString("Nation");
String str = String.format("Name:%s,Sex:%s,Age:%d,Nation:%s",name,sex,age,nation);
System.out.println(str);
}
} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
}finally {
try {
rs.close();
ps.close();
//ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//执行SQL语句,比如update、delete
public void executeSql(String sSql){
PreparedStatement ps = null;
int rs = 0;
try{
//1.发送sql语句
ps =getConnection().prepareStatement(sSql);
//2.执行
rs = ps.executeUpdate();
System.out.println(String.format("成功更新%d行数据",rs));
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
} finally {
try {
ps.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
e.printStackTrace();
}
}
}
}
SQlServer驱动下载地址:https://docs.microsoft.com/zh-cn/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-2017