-
大小: 0.27M文件類型: .zip金幣: 1下載: 0 次發(fā)布日期: 2021-02-20
- 語言: Java
- 標(biāo)簽:
資源簡介
Java 查詢本科部門經(jīng)理月收入情況(基礎(chǔ)篇-實(shí)例565).zip
代碼片段和文件信息
package?com.cdd.jdbc;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
public?class?FindLaborage?{
????
????private?Connection?conn;????
????public?Connection?getConn()?{
????????try?{
????????????Class.forName(“net.sourceforge.jtds.jdbc.Driver“);?//?加載數(shù)據(jù)庫驅(qū)動(dòng)
????????}?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對(duì)象
????}
????
????public?ResultSet?getMessageEmp()?{
????????conn?=?getConn();?//?獲取與數(shù)據(jù)庫的連接
????????try?{
????????
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2013-11-18?13:02??.classpath
?????文件?????????379??2010-09-10?15:23??.project
?????文件?????????629??2010-09-10?15:23??.settings\org.eclipse.jdt.core.prefs
?????文件????????3136??2013-11-21?08:42??bin\com\cdd\jdbc\FindLaborage.class
?????文件??????294726??2013-11-18?10:46??lib\jtds-1.2.2.jar
?????文件????????2553??2010-09-10?15:23??src\com\cdd\jdbc\FindLaborage.java
評(píng)論
共有 條評(píng)論