-
大小: 2.59MB文件類型: .zip金幣: 2下載: 0 次發(fā)布日期: 2023-11-12
- 語言: 數(shù)據(jù)庫
- 標(biāo)簽: 進(jìn)銷存??eclipse??
資源簡介
eclipse和Sqlserver數(shù)據(jù)庫開發(fā),適合初學(xué)者,借鑒學(xué)習(xí)。
整個(gè)項(xiàng)目實(shí)現(xiàn)了,進(jìn)銷存應(yīng)有的功能。

代碼片段和文件信息
package?Dao;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
public?class?baseDao?{
private?Connection?conn;
private?ResultSet?rs;
private?PreparedStatement??pstm;
public??Connection?getconn(){
try?{
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver“);
}?catch?(ClassNotFoundException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
String?url=“jdbc:sqlserver://localhost:1433;DatabaseName=db_jinxiaocun“;
try?{
conn=DriverManager.getConnection(url“sa““sa“);
????return?conn;
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
return?null;
}
public?void?closeAll(Connection?connPreparedStatement?pstmResultSet?rs){
try?{
if(rs!=null)rs.close();
if(pstm!=null)pstm.close();
if(conn!=null)conn.close();
}?catch?(SQLException?e)?{
//?TODO?Auto-generated?catch?block
e.printStackTrace();
}
}
public?void?update(String?sqlString?Array[]){
Connection?conn=null;
PreparedStatement?pstm=null;
try?{
conn=this.getconn();
pstm=conn.prepareStatement(sql);
for(int?i=0;i pstm.setString(i+1?Array[i]);
}
pstm.executeUpdate();
if(null!=pstm)?pstm.close();
if(null!=conn)?conn.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-12-09?18:38??三易進(jìn)銷存\
?????文件?????????369??2013-08-11?10:59??三易進(jìn)銷存\.classpath
?????文件?????????389??2013-08-31?16:02??三易進(jìn)銷存\.project
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\.settings\
?????文件?????????629??2013-08-11?10:57??三易進(jìn)銷存\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\ba
?????文件?????2293760??2013-09-09?21:11??三易進(jìn)銷存\ba
?????文件?????1114112??2013-09-09?21:11??三易進(jìn)銷存\ba
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\
?????文件????????2135??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\ba
?????文件????????4432??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\customerDao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\Employee\
?????文件????????2247??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\Employee\Dept_Dao.class
?????文件????????5303??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\Employee\EmployeeDao.class
?????文件????????8610??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\jinhuodanDao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\keyListener\
?????文件?????????682??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\keyListener\keyListener.class
?????文件????????6758??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\MoneyformDao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\moneyin\
?????文件????????5257??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\moneyin\Moneyindao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\moneylook\
?????文件????????2808??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\moneylook\Moneylookdao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\moneyout\
?????文件????????5262??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\moneyout\Moneyoutdao.class
?????文件????????2696??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\productClassDao.class
?????文件???????10186??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\productDao.class
?????文件????????3852??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\productListDao.class
?????文件????????2882??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\productSpecDao.class
?????文件????????1855??2013-09-09?20:33??三易進(jìn)銷存\bin\Dao\productUnitDao.class
?????目錄???????????0??2013-09-09?21:12??三易進(jìn)銷存\bin\Dao\RiZhi\
............此處省略413個(gè)文件信息
評論
共有 條評論