jdbc简单开发步骤 demo

框架用多了容易忘记传统jdbc的写法，直接上代码便于记忆。

package test;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;


public class DBTest {
	
	@Test
	static void test_1(){
		ResultSet rs = null;
		Statement st = null;
		Connection conn = null;
		try {
			//注册驱动
			Class.forName("com.mysql.jdbc.Driver");
			//获取连接
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bbs", "root" , "root");
			//获取statement
			st = conn.createStatement();
			//执行sql获取结果集
			rs = st.executeQuery("select * from article ");
			while(rs.next()){
				System.out.println(rs.getString("title"));
				System.out.println(rs.getDate("pdate"));
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(null!=rs){
					rs.close();
					rs = null;
				}
				if(null!=st){
					st.close();
					st = null;
				}
				if(null!=conn){
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	@Test
	static void test_2(){
		ResultSet rs = null;
		Statement st = null;
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root" , "root");
			st = conn.createStatement();
			
			int i = st.executeUpdate("insert  into user values('2','test2','11111','2013-04-05','1','0214111')");
			System.out.println(i);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(null!=rs){
					rs.close();
					rs = null;
				}
				if(null!=st){
					st.close();
					st = null;
				}
				if(null!=conn){
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	@Test
	static void test_3(){
		ResultSet rs = null;
		PreparedStatement st = null;
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root" , "root");
			// insert  into user values('2','test2','11111','2013-04-05','1','0214111')
			st = conn.prepareStatement("insert  into user values(?,?,?,?,?,?)");
			st.setInt(1, 4);
			st.setString(2, "test4");
			st.setString(3, "111111");
			st.setDate(4, new Date(System.currentTimeMillis()));
			st.setString(5, "1");
			st.setInt(6, 23254);
			int i = st.executeUpdate();
			System.out.println(i);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(null!=rs){
					rs.close();
					rs = null;
				}
				if(null!=st){
					st.close();
					st = null;
				}
				if(null!=conn){
					conn.close();
					conn = null;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}