package com.sql.zmz;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import javax.sql.RowSet;
public class Test1{
static Statement sql;
static Connection con;
static ResultSet res;
public Connection getConection() {
try {
Class.forName("com.mysql.jdbc.Driver");
System.out.println("数据库驱动加载成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
String url = "jdbc:mysql://localhost:3306/test_db?user=root&password=123456&useSSL=true";
try {
con = DriverManager.getConnection(url);
System.out.println("连接数据库成功");
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
return con;
}
public static void main(String[] args) {
Test1 c = new Test1();
con = c.getConection();
try {
sql = con.createStatement();
res = sql.executeQuery("select*from tb_emp1");
// res = sql.executeQuery("select*from tb_emp1 where name like '张%' ");
while(res.next()) {
String id = res.getString("id");
String name = res.getString("name");
String deptId = res.getString("deptId");
String salary = res.getString("salary");
System.out.print("编号:"+id);
System.out.print("姓名:"+name);
System.out.print("工号:"+deptId);
System.out.print("薪水"+salary);
System.out.println("");
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
}
}
加载和连接
最新推荐文章于 2022-05-23 18:11:45 发布