Java Statement 和 PrepareStatement 使用方法

//创建Statement对象
Statement stmt = conn.createStatement();//只读的结果集
//Statement stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);//可更新的结果集

//执行操作（增删改查）
ResultSet rs = stmt.executeQuery("select * from stt");

//处理结果
while(rs.next()){
        System.out.println(rs.getString("1"));
}

---------------------------------------------------------------

//创建prepareStatement对象

perstmt = con.prepareStatement("insert into tb_name (col1,col2,col2,col4) values (?,?,?,?)");
perstmt.setString(1,var1);
perstmt.setString(2,var2);
perstmt.setString(3,var3);
perstmt.setString(4,var4);
perstmt.executeUpdate();