实现数据库的连接,动态增、删、改、查功能
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Main {
public static void main(String[] args) {
try {
System.out.println("加载驱动");
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("加载驱动成功");
}
catch(Exception e){
System.out.println("加载驱动成功");
}
Connection con;
String uri= "jdbc:sqlserver://localhost:1433;DatabaseName=test;encrypt=true;trustServerCertificate=true";
try
{
String user="sa";
String password="123456";
System.out.println("开始连接数据库");
con=DriverManager.getConnection(uri,user,password);
System.out.println("连接数据库成功");
System.out.println("=======查询=========");
String sql = "Select * from 学生";
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while (rs.next()) {
String name = rs.getString(1);
int age = rs.getInt(2);
System.out.println(name + "==" + age);
}
System.out.println("=======插入=========");
sql ="insert into values ('赵吴', 34)"; int icount = st.executeUpdate(sql);
System.out.println("影响的行数:" + icount);
sql = "Select * from 学生"; st = con.createStatement();
rs =st.executeQuery(sql);
while (rs.next()) {
String name = rs.getString(1);
int age = rs.getInt(2);
System.out.println(name + "==" + age);
}
System.out.println("=======修改=========");
String updateName = "李四";
sql ="update 学生 set age = 50 where name = '" + updateName + "'";
icount = st.executeUpdate(sql);
System.out.println("影响的行数:" + icount);
sql = "Select * from 学生";
st = con.createStatement();
rs =st.executeQuery(sql);
while (rs.next()) {
String name = rs.getString(1);
int age = rs.getInt(2);
System.out.println(name + "==" + age);
}
System.out.println("=======删除=========");
int updateAge = 30;
sql = "Delete from 学生 where age > " + updateAge;
icount = st.executeUpdate(sql);
System.out.println("影响的行数:" + icount);
sql = "Select * from 学生";
st = con.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
String name = rs.getString(1);
int age = rs.getInt(2);
System.out.println(name + "==" + age);
}
}
catch(SQLException e) {
System.out.println(e.getMessage());
System.out.println("连接数据库失败");
}
}
}