/*数据库驱动*/
static final String JDBC_DRIVER="com.mysql.cj.jdbc.Driver";
/*数据库url*/
static final String DB_URL="jdbc:mysql://1.1.1.1:3308/ssss_aa_bb?serverTimezone=GMT%2B8&rewriteBatchedStatements=true&allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false";
//数据库名与密码
static final String user="root";
static final String pass="12345678";
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
try {
//注册驱动
Class.forName(JDBC_DRIVER);
System.out.println("-----连接数据库----");
//打开连接
conn= DriverManager.getConnection(DB_URL,user,pass);
//执行查询user表数据
stmt=conn.createStatement();
String sql;
sql="select OBJECT_ID,SYSUSER_NAME from plat_object_sysuser";
ResultSet rs=stmt.executeQuery(sql);
//数据输出
while(rs.next()){
int id=rs.getInt("OBJECT_ID" );
String name=rs.getString("SYSUSER_NAME");
System.out.println("ID="+id);
System.out.println("用户名="+name);
System.out.println();
}
//完成并关闭数据库
rs.close();
stmt.close();
conn.close();
System.out.println("查询结束关闭数据库");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException se){
se.printStackTrace();
}
}