資源簡介
本分頁系統采用JSP+JavaBean+Servlet實現。環境:Mysql+Tomcat+MyEclipse

代碼片段和文件信息
package?org.pagedemo.db;
import?java.io.IOException;
import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;
import?java.util.Properties;
import?org.pagedemo.po.User;
/**
?*?@author?qpy_2006
?*?
?*/
public?class?DBConnection?{
private?String?driverClassName;
private?String?username;
private?String?password;
private?String?url;
private?Connection?conn?=?null;
public?DBConnection()?{
String?fileName?=?“/DBConnect.properties“;
this.driverClassName?=?new?String(this.getPropertyValue(fileName
“driverClassName“));
this.url?=?this.getPropertyValue(fileName?“url“);
this.username?=?this.getPropertyValue(fileName?“username“);
this.password?=?this.getPropertyValue(fileName?“password“);
try?{
Class.forName(this.driverClassName);
this.conn?=?DriverManager.getConnection(this.url?this.username
this.password);
}?catch?(ClassNotFoundException?e)?{
System.err.println(“加載驅動程序出錯!!“?+?e.getMessage());
}?catch?(SQLException?e)?{
System.err.println(“獲取連接失敗!!!“?+?e.getMessage());
}
}
public?Connection?getConnection()?{
return?this.conn;
}
public?String?getPropertyValue(String?fileName?String?propName)?{
String?propertyValue?=?new?String(““);
InputStream?inStream?=?getClass().getResourceAsStream(fileName);
Properties?props?=?new?Properties();
try?{
props.load(inStream);
propertyValue?=?props.getProperty(propName);
if?(propertyValue?==?null)
propertyValue?=?““;
}?catch?(IOException?e)?{
System.err.println(“讀取數據庫配置文件失敗!!!“?+?e.getMessage());
propertyValue?=?null;
}
return?propertyValue;
}
//?測試數據庫的連接是否成功...
public?static?void?main(String[]?args)
{
DBConnection?db?=?new?DBConnection();
Connection?conn?=?db.getConnection();
String?sql?=?“select?*?from?t_page“;
PreparedStatement?pstmt;
List?users?=?new?ArrayList();
try?{
pstmt?=?conn.prepareStatement(sql);
ResultSet?rs?=?pstmt.executeQuery();
while(rs.next())
{
User?user?=?new?User();
user.setId(rs.getInt(“id“));
user.setStu_num(rs.getString(“stu_num“));
user.setUsername(rs.getString(“username“));
user.setAge(rs.getString(“age“));
users.add(user);
}
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}finally{
if(conn!=null)
try?{
conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
if(users.size()<1)
{
System.out.println(“沒有找到您要找的記錄!“);
}else
{
for(User?u:users)
{
System.out.println(“學生學號:?“+u.getStu_num());
System.out.println(“學生姓名:?“+u.getUsername());
System.out.println(“~~~~~~~~~~~~~~~“);
}
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1226??2008-09-15?14:47??PageDemo\.project
?????文件????????297??2008-09-15?13:57??PageDemo\.myme
?????文件????????551??2008-09-15?14:56??PageDemo\.classpath
?????文件????????544??2008-09-15?18:36??PageDemo\readme.txt
?????文件????????261??2008-09-15?16:27??PageDemo\src\DBConnect.properties
?????文件????????911??2008-09-15?16:11??PageDemo\src\pagedemo.sql
?????文件???????2677??2008-09-15?16:25??PageDemo\src\org\pagedemo\page\PageUtil.java
?????文件????????896??2008-09-15?16:25??PageDemo\src\org\pagedemo\page\PageDAO.java
?????文件???????3038??2008-09-15?15:52??PageDemo\src\org\pagedemo\db\DBConnection.java
?????文件????????623??2008-09-15?15:27??PageDemo\src\org\pagedemo\po\User.java
?????文件???????1687??2008-09-15?15:54??PageDemo\src\org\pagedemo\util\SetCharacterEncodingFilter.java
?????文件???????2307??2008-09-15?17:11??PageDemo\src\org\pagedemo\servlet\UserServlet.java
?????文件???????1965??2008-09-15?17:11??PageDemo\src\org\pagedemo\user\dao\UserDAO.java
?????文件???????2820??2008-09-15?17:32??PageDemo\WebRoot\index.jsp
?????文件???????1210??2008-09-15?17:36??PageDemo\WebRoot\toIndex.jsp
?????文件???????1327??2008-09-15?17:13??PageDemo\WebRoot\WEB-INF\web.xm
?????文件??????15999??2008-08-19?09:19??PageDemo\WebRoot\WEB-INF\c.tld
?????文件??????21195??2008-09-15?14:57??PageDemo\WebRoot\WEB-INF\lib\jstl.jar
?????文件?????394583??2008-09-15?14:57??PageDemo\WebRoot\WEB-INF\lib\standard.jar
?????文件????????911??2008-09-15?16:11??PageDemo\WebRoot\WEB-INF\classes\pagedemo.sql
?????文件????????261??2008-09-15?16:27??PageDemo\WebRoot\WEB-INF\classes\DBConnect.properties
?????文件???????1094??2008-09-15?15:27??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\po\User.class
?????文件???????2662??2008-09-15?16:25??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\page\PageUtil.class
?????文件???????1607??2008-09-15?16:25??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\page\PageDAO.class
?????文件???????4340??2008-09-15?15:52??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\db\DBConnection.class
?????文件???????2210??2008-09-15?15:54??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\util\SetCharacterEncodingFilter.class
?????文件???????2800??2008-09-15?17:11??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\servlet\UserServlet.class
?????文件???????2360??2008-09-15?17:11??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\user\dao\UserDAO.class
?????文件?????????39??2008-09-15?13:57??PageDemo\WebRoot\me
?????目錄??????????0??2008-09-15?18:38??PageDemo\WebRoot\WEB-INF\classes\org\pagedemo\user\dao
............此處省略28個文件信息
- 上一篇:JAVA的小賽車程序
- 下一篇:Android 圖片加圖片logo水印文字水印
評論
共有 條評論