資源簡(jiǎn)介
javaweb開(kāi)發(fā),連接Oracle數(shù)據(jù)庫(kù),通過(guò)網(wǎng)頁(yè)注冊(cè),登錄后對(duì)數(shù)據(jù)庫(kù)中的用戶表進(jìn)行增刪查。實(shí)現(xiàn)了登錄、注冊(cè)、增刪改查等功能。
代碼片段和文件信息
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)?{
//用來(lái)連接oracle數(shù)據(jù)庫(kù)
Connection?connection=null;
//執(zhí)行SQL語(yǔ)句
PreparedStatement?preparedStatement=null;
try?{
//加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)
Class.forName(“oracle.jdbc.OracleDriver“);
//數(shù)據(jù)庫(kù)地址jdbc:oracle:thin:@localhost:數(shù)據(jù)庫(kù)端口號(hào):數(shù)據(jù)庫(kù)SID
String?url=“jdbc:oracle:thin:@localhost:1521:orcl“;
//數(shù)據(jù)庫(kù)用戶名和密碼
String?userName=“system“;
String?userPassword=“088413“;
connection=DriverManager.getConnection(urluserNameuserPassword);
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\
?????文件?????????839??2018-12-24?14:57??jsp增刪改查\.classpath
?????文件?????????915??2019-01-04?18:02??jsp增刪改查\.project
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\.settings\
?????文件?????????567??2018-12-24?14:57??jsp增刪改查\.settings\.jsdtscope
?????文件?????????358??2018-12-24?14:57??jsp增刪改查\.settings\org.eclipse.jdt.core.prefs
?????文件?????????767??2018-12-30?14:07??jsp增刪改查\.settings\org.eclipse.wst.common.component
?????文件?????????343??2018-12-24?14:57??jsp增刪改查\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2018-12-24?14:57??jsp增刪改查\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-12-24?14:57??jsp增刪改查\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\classes\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\classes\com\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\classes\com\bzq\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\classes\com\bzq\dao\
?????文件????????2518??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\dao\DeleteDao.class
?????文件????????2366??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\dao\InsertDao.class
?????文件????????2975??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\dao\SelectDao.class
?????文件????????2764??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\dao\UpdateDao.class
?????目錄???????????0??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\model\
?????文件????????1566??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\model\UserModel.class
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\build\classes\com\bzq\servlet\
?????文件????????2200??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\servlet\DeleteServlet.class
?????文件????????2320??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\servlet\InsertServlet.class
?????文件????????2518??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\servlet\SelectServlet.class
?????文件????????2584??2019-01-04?18:02??jsp增刪改查\build\classes\com\bzq\servlet\UpdateServlet.class
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\src\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\src\com\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\src\com\bzq\
?????目錄???????????0??2019-01-09?21:12??jsp增刪改查\src\com\bzq\dao\
?????文件????????2500??2018-12-28?19:23??jsp增刪改查\src\com\bzq\dao\DeleteDao.java
............此處省略27個(gè)文件信息
- 上一篇:java小游戲推箱子
- 下一篇:jpcap32位和64位的ddl和jar
評(píng)論
共有 條評(píng)論