Mysql 驱动程序，连接数据库的代码
public static void main(String[] args) {
String usname= "root";
String pwd = "000000";
String driver="com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/zslm?user=root&password=000000"; //zslm是数据库名字，root是用户password//是密码
String sql = "select * from module";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName(driver); //加载驱动
conn = DriverManager.getConnection(url); //获得连接
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if (rs !=null){
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getDate(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
}
}else{
System.out.println("rs是null");
}
rs.close();
stmt.close();
rs.close();
} catch (ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
}
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
