PrepareStatement中的动态sql及时间处理动态sql
public int updateBooks(Books books)throws SQLException {
Connection conn = Connection();
//存储参数
List params =new ArrayList();
//存储参数类型
List type =new ArrayList();
String sql ="update tb_books ";
StringBuilder sb =new StringBuilder(sql);
//判断是否有添加
boolean flag =fal;
/
/动态添加sql语句
Author()!= null && Author().length()>0){
flag =true;
sb.append(" t author= ? ");
params.Author());
type.add("String");
}
BookName()!= null &&BookName().length()>0){
if(flag ==fal){
sb.append(" t bookName = ? ");
}el{
flag =true;
sb.append(" bookName = ? ");化验室
}
params.BookName());
type.add("String");
}
Price()!= null){
if(flag ==fal){
sb.append(" t price = ? ");
}el{
flag =true;
严实的拼音
sb.append(" price = ? ");
}
params.Price());
type.add("Double");
}
Publish()!= null){
if(flag ==fal){
sb.append(" t publish = ? ");
}el{
flag =true;
sb.append(" publish = ? ");
}
type.add("Date");
}
sb.append(" where id = ? ");
params.Id());
type.add("int");
PreparedStatement prep = conn.prepareStatement(sb +"");
for(int j =0; j < params.size(); j ++){
//判断类型
if("String".(j))){
prep.tString(j+(j).toString());
}
首都师范大学研究生if("int".(j))){
prep.tInt(j+1,Integer.(j).toString()));
}
if("Double".(j))){
prep.tDouble(j+1,Double.(j).toString()));
}
if("Date".(j))){
//将字符串的⽇期转换为java.util.Date再转换为java.sql.Date
prep.tDate(j+SqlDate(((j).toString()))));
}
围棋基础知识
}
int row = uteUpdate();
DBUtils.clo(conn,prep);
return row;
}1到100
⼯具类
public class DBUtils {
private static String url;
private static String urname;
private static String password;
private static String driver;
static{
Properties pro =new Properties();
InputStream in = ClassLoader().getResourceAsStream("jdbc.properties");
try{
pro.load(in);
url = Property("url");
urname = Property("urname");
password = Property("password");
driver = Property("driver");
Class.forName(driver);
}catch(IOException e){
e.printStackTrace();
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
//获取连接
public static Connection getConnection()throws SQLException {
Connection(url,urname,password);
}
//关闭资源
public static void clo(Connection conn, Statement stat, ResultSet rs){
豆瓣辣酱if(conn != null){
try{
conn.clo();
}catch(SQLException e){
e.printStackTrace();
}
居间合同协议书范本
}
if(stat != null){
try{
stat.clo();
}catch(SQLException e){
e.printStackTrace();
}
}
if(rs != null){
try{
rs.clo();
}catch(SQLException e){
e.printStackTrace();
丑牛年}
}
}
/
/关闭资源
public static void clo(Connection conn, Statement stat){
if(conn != null){
try{
conn.clo();
}catch(SQLException e){
e.printStackTrace();
}
}
if(stat != null){
try{
stat.clo();
}catch(SQLException e){
e.printStackTrace();
}
}
}
//java.util.Date --> java.sql.Date
public static java.sql.Date toSqlDate(java.util.Date date){
return new java.sql.Time());
}
//String(1970-11-11) --> java.util.Date
public static java.util.Date toUtilDate(String date){
SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
try{
return sdf.par(date);
}catch(ParException e){
}
return null;
}
//String() --> java.util.Date
public static java.util.Date toDate(String date){
SimpleDateFormat sdf =new SimpleDateFormat("yyyy-MM-dd");
try{
return sdf.par(sdf.format(new java.util.Date(date)));
}catch(Exception e){
}
return null;
}
}
