1.在官网下载mysql的jdbc驱动(附上链接:https://dev.mysql.com/downloads/connector/j/)
2.eclipse新建工程文件,在工程文件中新建lib目录,然后将这个jdbc连接Mysql数据库的驱动文件拖放到lib目录下
public class DUtilMysql {
/**测试连接mysql数据库
* @param args
*/
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
// 加载MYSQL JDBC驱动程序
// Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("Success loading Mysql Driver!");
} catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try {
Connection connect = DriverManager.getConnection("jdbc:mysql://服务器地址/数据库名", "你的用户", "你的密码");
// 连接URL为 jdbc:mysql//服务器地址/数据库名 ,后面的2个参数分别是登陆用户名和密码
System.out.println("Success connect Mysql server!");
Statement stmt = connect.createStatement();
String sql="select * from ge_lyqk_hjh a,ge_sfzhm_hjh b,ge_zfdz_hjh c where a.zjhm=b.zjhm and b.zjhm=c.zjhm and a.sex!=b.sex ";
ResultSet rs=stmt.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString("zjhm")+rs.getString("sex"));
}
} catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}