package t;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//mySql连接java
Driver driver=null;
try {
driver = new com.mysql.cj.jdbc.Driver();//加载驱动
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
DriverManager.deregisterDriver(driver);//驱动注册
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection connection=null;
try {
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/employee?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true", "root", "password");//获得连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Statement statement=null;
try {
statement=connection.createStatement();//获得statement对象
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql="select * from course ";//编写sql
ResultSet resultSet=null;
try {
resultSet=statement.executeQuery(sql);//获得结果集
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
while(resultSet.next()) {
System.out.println(resultSet.getString(1));//结果集解析
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
statement.close();//关闭statement对象
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//
try {
connection.close();//关闭连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
java连接mysql数据库和结果集解析
最新推荐文章于 2021-02-25 12:03:10 发布