mysql jdbc demo_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();

}

}

}

}