資源簡介
Java 對查詢結果進行格式化(基礎篇-實例575).zip
代碼片段和文件信息
package?com.cdd.laborage;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;
public?class?FindLaborage?{
????
????private?Connection?conn;
????
????public?Connection?getConn()?{
????????try?{
????????????Class.forName(“net.sourceforge.jtds.jdbc.Driver“);?//?加載數(shù)據(jù)庫驅動
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database23“;?//?連接數(shù)據(jù)庫URL
????????String?userName?=?“sa“;?//?連接數(shù)據(jù)庫的用戶名
????????String?passWord?=?““;?//?連接數(shù)據(jù)庫密碼
????????try?{
????????????conn?=?DriverManager.getConnection(url?userName?passWord);?//?獲取數(shù)據(jù)庫連接
????????????
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();
????????}
????????return?conn;?//?返回Connection對象
????}
????
????public?List?getPatindex()?{
????????con
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2013-11-18?14:24??.classpath
?????文件?????????379??2010-09-10?15:23??.project
?????文件?????????629??2010-09-10?15:23??.settings\org.eclipse.jdt.core.prefs
?????文件????????3714??2013-11-21?08:42??bin\com\cdd\laborage\FindLaborage.class
?????文件????????1334??2013-11-21?08:42??bin\com\cdd\laborage\ParticularLaborage.class
?????文件??????294726??2013-11-18?10:46??lib\jtds-1.2.2.jar
?????文件????????2977??2010-09-10?15:23??src\com\cdd\laborage\FindLaborage.java
?????文件?????????876??2010-09-10?15:23??src\com\cdd\laborage\ParticularLaborage.java
- 上一篇:Java 使用NOT查詢不滿足條件的記錄
- 下一篇:Java 平移面板控件
評論
共有 條評論