package readData;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class MysqlDemo {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con = null;
try {
// 获得MySQL驱动的实例
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 提供地址用户名密码并获得连接对象
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "123456");
if (!con.isClosed())
// 连接成功提示
System.out.println("Successfully connected to MySQL server using TCP/IP...");
// 有Connection对象创建Statement
Statement st = con.createStatement();
// 运行SQL语句读取
ResultSet rs = st.executeQuery("SELECT * FROM students");
// 循环读取数据
while (rs.next()) {
// 打印数据
System.out.println(rs.getString("id")+" "+rs.getString("name"));
}
// 关闭
con.close();
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class MysqlDemo {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection con = null;
try {
// 获得MySQL驱动的实例
Class.forName("com.mysql.jdbc.Driver").newInstance();
// 提供地址用户名密码并获得连接对象
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "123456");
if (!con.isClosed())
// 连接成功提示
System.out.println("Successfully connected to MySQL server using TCP/IP...");
// 有Connection对象创建Statement
Statement st = con.createStatement();
// 运行SQL语句读取
ResultSet rs = st.executeQuery("SELECT * FROM students");
// 循环读取数据
while (rs.next()) {
// 打印数据
System.out.println(rs.getString("id")+" "+rs.getString("name"));
}
// 关闭
con.close();
} catch(Exception e) {
System.err.println("Exception: " + e.getMessage());
}
}
}