資源簡介
代碼放在java目錄下,然后將hk.sql導入MySQL,主程序為“daima\num_02\JavaPrj_2\bin\com\hk\server\ServerMainClass.class”。基于Hibernate框架的應用,需要導入Hibernate開發包。

代碼片段和文件信息
package?com.hk.base;
import?java.sql.*;
public?class?Business{
//加載驅動,創建連接,釋放資源
private?static?final?String?driver?=?“com.mysql.jdbc.Driver“;
private?static?final?String?url=“jdbc:mysql://127.0.0.1:3306/zk“;
private?static?final?String?username=“root“;
private?static?final?String?pwd=“root“;
static{
try{
Class.forName(driver);
}catch(Exception?e){
e.printStackTrace();
}
}
public?static?Connection?getConnection(){
Connection?con?=?null;
try{
con?=?DriverManager.getConnection(urlusernamepwd);
}catch(Exception?e){
e.printStackTrace();
}
return?con;
}
public?static?void?release(ResultSet?rsStatement?stmtConnection?con){
try{if(rs!=null)rs.close();}catch(Exception?e){e.printStackTrace();}
try{if(stmt!=null)stmt.close();}catch(Exception?e){e.printStackTrace();}
try{if(con!=null)con.close();}catch(Exception?e){e.printStackTrace();}
if(rs==null)System.out.println(“rs==null“+“util“);
}
public?static?void?release(object?o){
try{
if(o?instanceof?ResultSet){
((ResultSet)o).close();
}else?if(o?instanceof?Statement){
((Statement)o).close();
}else?if(o?instanceof?Connection){
((Connection)o).close();
}
}catch(Exception?e){
e.printStackTrace();
}
}
public?static?void?printRs(ResultSet?rs){
if(rs==null)?return;
try{
ResultSetmetaData?md?=?rs.getmetaData();
int?colmun?=?md.getColumnCount();
StringBuffer?sb?=?new?StringBuffer();
for(int?i=1;?i<=colmun;?i++){
sb.append(md.getColumnName(i)+“\t“);
}
sb.append(“\n“);
while(rs.next()){
for(int?i=1;?i<=colmun;?i++){
sb.append(rs.getString(i)+“\t“);
}
sb.append(“\n“);
}
System.out.println(sb.toString());
}catch(Exception?e){
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-08-04?11:01??num_02\
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\
?????文件????????1216??2015-07-28?00:13??num_02\JavaPrj_2\.classpath
?????文件?????????435??2010-06-03?13:51??num_02\JavaPrj_2\.myhibernatedata
?????文件??????????66??2010-06-03?13:51??num_02\JavaPrj_2\.myumldata
?????文件?????????719??2010-11-07?20:58??num_02\JavaPrj_2\.project
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\.settings\
?????文件??????????55??2015-07-27?20:30??num_02\JavaPrj_2\.settings\org.eclipse.core.resources.prefs
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\bin\
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\bin\com\
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\bin\com\hk\
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????3040??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件?????????512??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????6019??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????1060??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件?????????272??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????3091??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件?????????657??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????6610??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件?????????407??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????文件????????4760??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\ba
?????目錄???????????0??2015-08-04?11:01??num_02\JavaPrj_2\bin\com\hk\client\
?????文件????????5356??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\AddOrder.class
?????文件????????2830??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\ClientMain.class
?????文件????????1719??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\ClientMainfr
?????文件????????4431??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\ClientMainfr
?????文件????????2092??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\FlightTableModel.class
?????文件????????4568??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\Loginfr
?????文件????????4049??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\ModifyPasswd.class
?????文件????????5340??2015-07-28?00:13??num_02\JavaPrj_2\bin\com\hk\client\Orderfr
............此處省略135個文件信息
評論
共有 條評論