package com.dada.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class TestMysql {
public static void main(String[] args) throws Exception {
getConnByOrgDriver();
PreparedStatement psmt = conn.prepareStatement("select * from student");
ResultSet rs = psmt.executeQuery();
while (rs.next()) {
System.out.println("编号:" + rs.getInt(1) + " " + "姓名:"
+ rs.getString(2));
}
}
private static Connection conn;
/**通过加载com.mysql.jdbc.Driver驱动类来获取连接
* @throws Exception
*/
public static void getConnByJdbcDriver() throws Exception {
String url = "jdbc:mysql://localhost/dadasport?user=root&password=hdx&characterEncoding=utf-8";
Class clazz = Class.forName("com.mysql.jdbc.Driver");
System.out.println("驱动名称" + clazz.getName());
conn = DriverManager.getConnection(url);
}
/**通过加载org.gjt.mm.mysql.Driver驱动类来获取连接
* @throws Exception
*/
public static void getConnByOrgDriver() throws Exception {
String url = "jdbc:mysql://localhost/dadasport?user=root&password=hdx&characterEncoding=utf-8";
Class clazz = Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("驱动名称" + clazz.getName());
conn = DriverManager.getConnection(url);
}
}