package com.bzq.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import com.bzq.model.UserModel;
public class DeleteDao {
public static int deleteMode=-1;
public static void main(String[] args) {
}
public static void delete(UserModel um) {
//用来连接oracle数据库
Connection connection=null;
//执行SQL语句
PreparedStatement preparedStatement=null;
try {
//加载数据库驱动
Class.forName("oracle.jdbc.OracleDriver");
//数据库地址jdbc:oracle:thin:@localhost:数据库端口号:数据库SID
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//数据库用户名和密码
String userName="system";
String userPassword="088413";
connection=DriverManager.getConnection(url,userName,userPassword);
//sql语句，？代表动态赋值
String strSql="delete users where id=?";//,sex=?,age=?,password=?
System.out.println(strSql);
//执行sql语句
preparedStatement=connection.prepareStatement(strSql);
System.out.println("dao:"+um.getId());
preparedStatement.setString(1,um.getId());
// preparedStatement.setString(2,um.getSex());
// preparedStatement.setString(3,um.getAge());
//提交sql语句到数据库insertMode=
deleteMode=preparedStatement.executeUpdate();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally {
try {
connection.close();
preparedStatement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
// public static String StrSql(UserModel um){
// String n=um.getName();
// String s=um.getSex();
// String a=um.getAge();
//
//
// String strSql=null;
// if ((n!="")&&(s!="")&&(a!="")) {
// strSql="delete users where name=? and sex=? and age=?";
// }
// if ((n!="")&&(s!="")&&(a=="")) {
// strSql= "delete users where name=? and sex=?";
// }
// if ((n!="")&&(s=="")&&(a!="")) {
// strSql= "delete users where name=? and age=?";
// }
// if ((n=="")&&(s!="")&&(a!="")) {
// strSql="delete users where sex=? and age=?";
// }
// if ((n!="")&&(s=="")&&(a=="")) {
// strSql= "delete users where name=?";
// }
// if ((n=="")&&(s!="")&&(a=="")) {
// strSql= "delete users where sex=?";
// }
// if ((n=="")&&(s=="")&&(a!="")) {
// strSql= "delete users where age=?";
// }
//
// return strSql;
//
// }
}
jsp增删改查.zip （39个子文件） 
jsp增删改查 
.project 915B WebContent WEB-INF lib 
servlet-api.jar 238KB jstl.jar 20KB classes12.jar 1.12MB standard.jar 384KB web.xml 2KB register.jsp 804B registerSuccess.jsp 620B registerFail.jsp 620B update.jsp 1018B loginFail.jsp 743B META-INF MANIFEST.MF 39B login.jsp 1KB loginSuccess.jsp 1KB src com bzq model UserModel.java 953B dao SelectDao.java 2KB DeleteDao.java 2KB InsertDao.java 2KB UpdateDao.java 2KB servlet UpdateServlet.java 2KB DeleteServlet.java 1KB SelectServlet.java 2KB InsertServlet.java 1KB .settings org.eclipse.wst.jsdt.ui.superType.container 49B org.eclipse.wst.common.project.facet.core.xml 343B org.eclipse.jdt.core.prefs 358B org.eclipse.wst.jsdt.ui.superType.name 6B org.eclipse.wst.common.component 767B .jsdtscope 567B build classes com bzq model UserModel.class 2KB dao DeleteDao.class 2KB InsertDao.class 2KB UpdateDao.class 3KB SelectDao.class 3KB servlet SelectServlet.class 2KB DeleteServlet.class 2KB InsertServlet.class 2KB UpdateServlet.class 3KB .classpath 839B
评论0
最新资源