資源簡介
Java 將數據從一張表復制到另一張表(基礎篇-實例517).zip
代碼片段和文件信息
package?com.cdd.util;
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?CopyDate?{
????private?Connection?conn;
????
????public?Connection?getConn()?{
????????try?{
????????????Class.forName(“net.sourceforge.jtds.jdbc.Driver“);?//?加載數據庫驅動
????????}?catch?(ClassNotFoundException?e)?{
????????????e.printStackTrace();
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database22“;?//?連接數據庫URL
????????String?userName?=?“sa“;?//?連接數據庫的用戶名
????????String?passWord?=?““;?//?連接數據庫密碼
????????try?{
????????????conn?=?DriverManager.getConnection(url?userName?passWord);?//?獲取數據庫連接
??????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:52??.classpath
?????文件?????????379??2015-08-28?13:52??.project
?????文件?????????629??2015-08-28?13:52??.settings\org.eclipse.jdt.core.prefs
?????文件????????2887??2015-08-28?13:52??bin\com\cdd\util\CopyDate.class
?????文件?????????744??2015-08-28?13:52??bin\com\cdd\util\Copyfr
?????文件?????????712??2015-08-28?13:52??bin\com\cdd\util\Copyfr
?????文件????????3956??2015-08-28?13:52??bin\com\cdd\util\Copyfr
?????文件????????1294??2015-08-28?13:52??bin\com\cdd\util\ExcellenceStu.class
?????文件?????????937??2015-08-28?13:52??bin\com\cdd\util\LocalTableModel.class
?????文件??????294726??2015-08-28?13:52??lib\jtds-1.2.2.jar
?????文件????????2466??2015-08-28?13:52??src\com\cdd\util\CopyDate.java
?????文件????????3407??2015-08-28?13:52??src\com\cdd\util\Copyfr
?????文件?????????876??2015-08-28?13:52??src\com\cdd\util\ExcellenceStu.java
?????文件?????????630??2015-08-28?13:52??src\com\cdd\util\LocalTableModel.java
評論
共有 條評論