package com.test;
import java.sql.DriverManager;
import java.sql.ResultSet;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
public class TestNet {
private static Connection conn = null ;
public static Connection getCon_jdbc(){
String url = "jdbc:mysql://localhost:3306/test";
String driver = "com.mysql.jdbc.Driver";
String userName="root";
String password="";
/* 执行Class.forName('驱动类名')方法
* 将驱动类的class文件装载到内存中,并且形成一个描述此驱动类结构的Class类实例,
并且初始化此驱动类,这样jvm就可以使用它了,这就是Class.forName()方法的含义。
*/
try {
Class.forName(driver).newInstance();
conn= (Connection) DriverManager.getConnection(url, userName, password);
return conn;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
public void closeConn(){
try {
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
Connection conn;
TestNet t = new TestNet();
conn = t.getCon_jdbc();
try {
String sql = "select * from sys_user";
// Statement st = (Statement) conn.createStatement();
PreparedStatement pst = (PreparedStatement) conn.prepareStatement(sql);
// ResultSet rs = st.executeQuery(sql);
ResultSet rs = pst.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("name"));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
t.closeConn();
}
}
}
import java.sql.DriverManager;
import java.sql.ResultSet;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
import com.mysql.jdbc.Statement;
public class TestNet {
private static Connection conn = null ;
public static Connection getCon_jdbc(){
String url = "jdbc:mysql://localhost:3306/test";
String driver = "com.mysql.jdbc.Driver";
String userName="root";
String password="";
/* 执行Class.forName('驱动类名')方法
* 将驱动类的class文件装载到内存中,并且形成一个描述此驱动类结构的Class类实例,
并且初始化此驱动类,这样jvm就可以使用它了,这就是Class.forName()方法的含义。
*/
try {
Class.forName(driver).newInstance();
conn= (Connection) DriverManager.getConnection(url, userName, password);
return conn;
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
return null;
}
}
public void closeConn(){
try {
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
Connection conn;
TestNet t = new TestNet();
conn = t.getCon_jdbc();
try {
String sql = "select * from sys_user";
// Statement st = (Statement) conn.createStatement();
PreparedStatement pst = (PreparedStatement) conn.prepareStatement(sql);
// ResultSet rs = st.executeQuery(sql);
ResultSet rs = pst.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString("name"));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
t.closeConn();
}
}
}