自己写的java连接mysql数据库的例子

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();
				}
			}
		}
		
	}
}
}