JDBC小小实例教程

public class Base {

	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		template();
	}
	static void template() throws Exception
	{

		Connection conn=null;
		Statement st=null;
		ResultSet resultset=null;

		try {
			//2.建立连接
			conn=JdbcUtils.getConnection();
			//3.创建语句
			st=conn.createStatement();
			//4.执行语句
			resultset=st.executeQuery("select *from user");
			//5.处理结果
			while(resultset.next())
			{
				System.out.println(resultset.getObject(1));
				System.out.println(resultset.getObject(2));
				System.out.println(resultset.getObject(3));
				System.out.println(resultset.getObject(4));
			}

		} finally
		{
			JdbcUtils.free(resultset, st, conn);
		}

	}}
public class JdbcUtils 
{
	private static String url="jdbc:mysql://localhost:3306/jdbc";
	private static String user="root";
	private static String password="123";
	private JdbcUtils()
	{
	}
	static
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
		}
		catch(ClassNotFoundException e)
		{
			throw new ExceptionInInitializerError(e);
		}
	}
	public static Connection getConnection() throws SQLException
	{
		return DriverManager.getConnection(url, user, password);
	}
	public static void free(ResultSet resultset,Statement st,Connection conn)
	{
		//6.释放资源
		try{
		if(resultset!=null)
			resultset.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(st!=null)
					st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			finally
			{
				if(conn!=null)
					try {
						conn.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
			}
		}
	}
}