-
大小: 1.11MB文件類型: .rar金幣: 2下載: 0 次發布日期: 2023-09-19
- 語言: Java
- 標簽:
資源簡介
java留言板,代碼,數據庫java留言板,代碼,數據庫java留言板,代碼,數據庫java留言板,代碼,數據庫java留言板,代碼,數據庫

代碼片段和文件信息
package?QueryDao;
import?java.sql.Connection;
import?java.util.*;
import?UserBean.Write;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?javax.naming.spi.DirStateFactory.Result;
import?UserBean.Reply;
import?UserBean.User;
import?UserBean.Traveler;
public?class?Query?{
int?count=0;
public?int?getCount()?{
return?count;
}
public?void?setCount(int?count)?{
this.count?=?count;
}
Write?write;
User?user;
//此DAO用于數據庫的連接
private?Connection?con;
//采用構造函數對數據庫進行初始化
public?Query(){
try?{
Class.forName(“com.mysql.jdbc.Driver“);
try?{
con=DriverManager.getConnection(“jdbc:mysql://localhost:3306/write““root“““);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}?catch?(ClassNotFoundException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
//用戶注冊
public?void?QueryReg(User?user){
String?sql=“insert?into?user?values(“+“null“+“‘“+user.getUsername()+“‘‘“+user.getPassword()+“‘‘“+user.getTelphone()+“‘‘“+user.getQq()+“‘‘“+user.getEmail()+“‘);“;
System.out.println(user.getUsername());
try?{
con.createStatement().execute(sql);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
try?{
con.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
//用戶登陸
public?void?QueryLogin(User?user){
String?sql=“select?*?from?user?where?username=‘“+user.username+“‘?and?password=‘“+user.password+“‘;“;
try?{
ResultSet?rs=con.createStatement().executeQuery(sql);
while(rs.next()){
count=rs.getInt(1);
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
//管理員登陸
public?void?QueryAdminLogin(User?user){
String?sql=“select?*?from?admin?where?username=‘“+user.username+“‘?and?password=‘“+user.password+“‘;“;
try?{
ResultSet?rs=con.createStatement().executeQuery(sql);
while(rs.next()){
count=rs.getInt(1);
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
//將留言寫進數據庫
public?void?QueryWrite(Write?write){
java.sql.Timestamp?nowTime=new?java.sql.Timestamp(write.getDate().getTime());
String?sql=“insert?into?user_write?values(“+“null“+“‘“+write.getUsername()+“‘‘“+write.gettitle()+“‘‘“+write.getContent()+“‘‘“+nowTime+“‘‘“+write.getState()+“‘‘“+write.getReplystate()+“‘);“;
try?{
con.createStatement().execute(sql);
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
//查看用戶所有留言,進行留言管理(刪除)
public?ArrayList?QuerySelect(Write?write){
ArrayList?al=new?ArrayList();
String?sql=“select?*?from?user_write?where?username=‘“+write.getUsername()+“‘;“;
try?{
ResultSet?rs=con.createStatement().executeQuery(sql);
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????588??2011-09-27?13:02??Writern\.classpath
?????文件???????1040??2011-09-27?13:02??Writern\.project
?????文件????????503??2011-09-27?13:02??Writern\.settings\.jsdtscope
?????文件????????450??2011-10-09?16:50??Writern\.settings\org.eclipse.core.resources.prefs
?????文件????????395??2011-09-27?13:02??Writern\.settings\org.eclipse.jdt.core.prefs
?????文件????????451??2011-09-27?13:02??Writern\.settings\org.eclipse.wst.common.component
?????文件????????305??2011-09-27?13:02??Writern\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2011-09-27?13:02??Writern\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2011-09-27?13:02??Writern\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????14379??2011-10-21?15:48??Writern\build\classes\QueryDao\Query.class
?????文件???????4451??2011-10-14?18:15??Writern\build\classes\SendEmail\SendTest.class
?????文件???????2164??2011-10-14?16:36??Writern\build\classes\Servlet\ServletAdminLogin.class
?????文件???????3042??2011-10-14?17:19??Writern\build\classes\Servlet\ServletAdminReplyTraveler.class
?????文件???????3793??2011-10-14?16:36??Writern\build\classes\Servlet\ServletAdminUserReply.class
?????文件???????2423??2011-10-14?16:36??Writern\build\classes\Servlet\ServletAdminWriteManager.class
?????文件???????2083??2011-10-14?16:36??Writern\build\classes\Servlet\ServletAdminWriteManagerSimple.class
?????文件???????2391??2011-10-14?16:36??Writern\build\classes\Servlet\ServletDelete.class
?????文件???????2078??2011-10-14?16:36??Writern\build\classes\Servlet\ServletDeleteWrite.class
?????文件???????2139??2011-10-14?16:36??Writern\build\classes\Servlet\ServletLogin.class
?????文件???????1775??2011-10-14?16:36??Writern\build\classes\Servlet\ServletReg.class
?????文件???????2312??2011-10-14?16:36??Writern\build\classes\Servlet\ServletReply.class
?????文件???????1836??2011-10-14?16:36??Writern\build\classes\Servlet\ServletReplyOk.class
?????文件???????5718??2011-10-14?16:36??Writern\build\classes\Servlet\ServletSelect.class
?????文件???????1846??2011-10-14?16:36??Writern\build\classes\Servlet\ServletTravelerDelete.class
?????文件???????1873??2011-10-14?16:36??Writern\build\classes\Servlet\ServletTravelerManager.class
?????文件???????2575??2011-10-14?17:42??Writern\build\classes\Servlet\ServletTravelerManagerSimple.class
?????文件???????2113??2011-10-14?16:36??Writern\build\classes\Servlet\ServletTravelerReply.class
?????文件???????2036??2011-10-14?16:36??Writern\build\classes\Servlet\ServletTravelerWrite.class
?????文件???????1930??2011-10-14?16:36??Writern\build\classes\Servlet\ServletUserDelete.class
?????文件???????1554??2011-10-14?16:36??Writern\build\classes\Servlet\ServletUserManager.class
............此處省略83個文件信息
- 上一篇:抓住神經貓源碼
- 下一篇:Android+3D+游戲開發教程.zip
評論
共有 條評論