資源簡介
Struts2實現增刪改查和登錄校驗，并運用了mysql數據庫。適合快速的掌握struts2的原理
代碼片段和文件信息
package?dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ParametermetaData;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Types;
import?java.util.Arrays;
import?java.util.List;
import?java.util.Map;
public?class?CommonDao?{
private?String?url?=?“jdbc:mysql://localhost:3306/j2eestudent?Unicode=true&characterEncoding=UTF-8“;
private?String?userName?=?“root“;
private?String?password??=?“root“;
private?String?jdbcDriver?=?“com.mysql.jdbc.Driver“;
public?Connection?con（）{
Connection?con?=?null;
try?{
Class.forName（jdbcDriver）;
con?=?DriverManager.getConnection（url?userName?password）;
}?catch?（Exception?e）?{
e.printStackTrace（）;
}
return?con;
}
@SuppressWarnings（“unchecked“）
public?Listject>>?excuteQuery（String?sqlobject[]?o）{
return?（Listject>>）?excuteQuery（sql?o?new?ListMapHander（））;
}
public?ResultSet?excuteQuery（String?sql）{
Connection?con?=?null;
ResultSet?rs?=?null;
con?=?this.con（）;
try?{
rs?=?con.createStatement（）.executeQuery（sql）;
}?catch?（SQLException?e）?{
e.printStackTrace（）;
}
return?rs;
}
public?object?excuteQuery（String?sqlobject[]?oResultSetHander?rsh）{
PreparedStatement?pstmt=null;
Connection?con?=?null;
ResultSet?rs?=?null;
try?{
System.out.println（“SQL:“+sql+“;?參數:“+Arrays.deepToString（o））;
con?=?this.con（）;?
pstmt?=?con.prepareStatement（sql）;
//填充PreparedStatement的參數
fillStatement（pstmto）;
rs?=?pstmt.executeQuery（）;
return?rsh.doHander（rs）;
}?catch?（Exception?e）?{
e.printStackTrace（）;
}finally{
//關閉數據庫連接
close（conpstmtrs）;
}
return?null;
}
public?int?executeUpdate（String?sqlobject[]?o）{
PreparedStatement?pstmt=null;
Connection?con?=?null;
try?{
con?=?this.con（）;?
con.setAutoCommit（false）;//取消自動提交開啟事務
pstmt?=?con.prepareStatement（sql）;
System.out.println（“SQL:“+sql+“;?參數:“+Arrays.deepToString（o））;
//填充PreparedStatement的參數
fillStatement（pstmto）;
int?result?=0;
try{
?result?=?pstmt.executeUpdate（）;
}catch（Exception?e）{
System.out.println（e.getMessage（））;
}
con.commit（）;//提交事務
con.setAutoCommit（true）;//關閉事務
return?result;
}?catch?（Exception?e）?{
try?{
con.rollback（）;//回滾
if（!con.getAutoCommit（））{
con.setAutoCommit（true）;
}
}?catch?（SQLException?e1）?{
e1.printStackTrace（）;
}
e.printStackTrace（）;
}finally{
close（conpstmtnull）;//關閉連接
}
return?-1;
}
private?void?close（Connection?con?PreparedStatement?pstmt?ResultSet?rs）?{
if（rs?!=?null）{
try?{
rs.close（）;
}?catch?（SQLException?e）?{
e.pr ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????2035??2014-12-30?17:00??Struts2實現增刪改查和登錄校驗\j2eestudent.sql
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\
?????文件?????????630??2014-12-22?16:59??Struts2實現增刪改查和登錄校驗\J2EE-Test3\.classpath
?????目錄???????????0??2014-12-22?16:58??Struts2實現增刪改查和登錄校驗\J2EE-Test3\.myeclipse\
?????文件?????????303??2014-12-22?16:58??Struts2實現增刪改查和登錄校驗\J2EE-Test3\.myme
?????文件?????????240??2014-12-22?16:59??Struts2實現增刪改查和登錄校驗\J2EE-Test3\.mystrutsdata
?????文件????????1836??2014-12-22?17:32??Struts2實現增刪改查和登錄校驗\J2EE-Test3\.project
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\dao\
?????文件????????4869??2014-12-19?20:35??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\dao\CommonDao.java
?????文件?????????823??2014-12-19?20:04??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\dao\ListMapHander.java
?????文件?????????166??2014-12-19?20:04??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\dao\ResultSetHander.java
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\
?????文件????????1175??2014-12-22?21:27??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\AddStudent.java
?????文件?????????784??2014-12-22?21:32??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\DeleteStudent.java
?????文件????????1966??2014-12-25?11:04??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\LoginAction.java
?????文件?????????964??2014-12-25?10:23??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\LoginAction-validation.xm
?????文件????????1297??2014-12-21?23:08??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\RegisterAction.java
?????文件????????1198??2014-12-21?10:30??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\StudentManage.java
?????文件????????1177??2014-12-22?17:17??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\UpdateStudent.java
?????文件?????????788??2014-12-22?20:44??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\action\UpdateStudentById.java
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\dao\
?????文件????????2954??2014-12-22?20:44??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\dao\StudentDao.java
?????文件?????????862??2014-12-21?23:16??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\dao\UserDao.java
?????目錄???????????0??2014-12-30?17:07??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\entity\
?????文件?????????659??2014-12-20?20:53??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\entity\FileUtil.java
?????文件?????????487??2014-12-19?20:59??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\entity\Student.java
?????文件?????????422??2014-12-19?20:58??Struts2實現增刪改查和登錄校驗\J2EE-Test3\src\org\cqut\zc\entity\User.java
............此處省略59個文件信息
評論
共有 條評論
川公網安備 51152502000135號