base.java
import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public class Base{
public static void main(String[] args) throws Exception{
template();
//testjdbc();
}
static void template() throws Exception{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = jdbcUtils.getConnection();
st = (Statement) conn.createStatement();
rs = (ResultSet) st.executeQuery("select * from user");
while (rs.next()) {
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)+"\t" + rs.getObject(4));
}
}
// 6.释放资源
finally{
jdbcUtils.free(conn, st, rs);
}
/*try{
if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
}finally{
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
}
*/
}
static void testjdbc() throws Exception{
Connection conn=null;
Statement st=null;
ResultSet rs=null;
// 1.注册驱动
/*DriverManager.registerDriver(new com.mysql.jdbc.Driver());
System.setProperty("jdbc.drivers", "com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver");*/
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 2.建立连接
conn = (Connection) DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=ZLdatabase", "sa","lei2338245");
// 3.创建语句
st = (Statement) conn.createStatement();
// 4.执行语句
rs = (ResultSet) st.executeQuery("select * from 教师表");
// 5.处理结果
while (rs.next()) {
System.out.println(rs.getObject(1) + "\t" + rs.getObject(2));
}
// 6.释放资源
rs.close();
st.close();
conn.close();
}
}
jdbcUtils.java
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.ResultSet;
import com.mysql.jdbc.Statement;
public final class jdbcUtils {
private static String url="jdbc:mysql://localhost:3306/test";
private static String user="root";
private static String password="root";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
private jdbcUtils(){
}
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
throw new ExceptionInInitializerError(e);
}
}
public static Connection getConnection() throws SQLException{
return (Connection) DriverManager.getConnection(url,user,password);
}
public static void free(Connection conn,Statement st,ResultSet rs){
try{
if(rs!=null){
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try{
if(st!=null){
st.close();
}}catch(SQLException e){
e.printStackTrace();
}finally{
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
}