http://www.cnblogs.com/zilong882008/archive/2011/11/12/2246521.html
package cn.com.JDBC;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class CRUD {
public static void main(String[] args) throws SQLException {
// TODO Auto-generated method stub
//create();
//update();
delete();
read();
}
static void delete() throws SQLException
{
Connection conn=null;
Statement st=null;
ResultSet resultset=null;
try {
//2.建立连接
conn=JdbcUtils.getConnection();
//单例设计模式
conn=JdbcUtilsSingle.getInstance().getConnection();
//3.创建语句
st=conn.createStatement();
//4.执行语句
String sql="delete from user where id>5";
int i=st.executeUpdate(sql);
System.out.println("i="+i);
} finally
{
JdbcUtils.free(resultset, st, conn);
}
}
static void update() throws SQLException
{