package com.shop.db;
import java.sql.*;
import java.io.*;
import java.util.*;
public class connDB {
public Connection conn = null;
public Statement stmt = null;
public ResultSet rs = null;
private static String propFileName = "D:/workspace/shop/db/connDB.properties";
private static Properties prop = new Properties();
private static String dbClassName =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String dbUrl =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop";
private static String dbUser = "sa";
private static String dbPwd = "sa";
private static void loadProperty() {
try {
prop.load(new FileInputStream(propFileName)); //通过文件输入流对象加载Properties文件
dbClassName = prop.getProperty("DB_CLASS_NAME");
dbUrl = prop.getProperty("DB_URL",
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_shop");
dbUser = prop.getProperty("DB_USER", "sa");
dbPwd = prop.getProperty("DB_PWD", "sa");
}
catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn = null;
loadProperty();
try {
Class.forName(dbClassName).newInstance();
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
}
catch (Exception ee) {
ee.printStackTrace();
}
if (conn == null) {
System.err.println(
"警告: DbConnectionManager.getConnection() 获得数据库链接失败.\r\n\r\n链接类型:" +
dbClassName + "\r\n链接位置:" + dbUrl + "\r\n用户/密码" + dbUser + "/" +
dbPwd);
}
return conn;
}
/*
*功能:执行查询语句
*/
public ResultSet executeQuery(String sql) {
try {
conn = getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
/*
*功能:执行更新操作
*/
public int executeUpdate(String sql) {
int result = 0;
try {
conn = getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
}
catch (SQLException ex) {
result = 0;
}
try {
stmt.close();
}
catch (SQLException ex1) {
}
return result;
}
public int executeUpdate_id(String sql) {
int result = 0;
try {
conn = getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
result = stmt.executeUpdate(sql);
String ID = "select @@IDENTITY as id";
rs = stmt.executeQuery(ID);
if (rs.next()) {
int autoID = rs.getInt("id");
result = autoID;
}
}
catch (SQLException ex) {
result = 0;
}
return result;
}
/*
*功能:关闭数据库的连接
*/
public void close() {
try {
if (rs != null) {
rs.close();
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
try {
if (stmt != null) {
stmt.close();
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
try {
if (conn != null) {
conn.close();
}
}
catch (Exception e) {
e.printStackTrace(System.err);
}
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
Eclipse写的商城购物系统
共217个文件
gif:78个
jsp:64个
jpg:22个
4星 · 超过85%的资源 需积分: 41 28 下载量 46 浏览量
2008-04-07
17:50:10
上传
评论 1
收藏 2.32MB RAR 举报
温馨提示
毕业设计,JSP做的购物商城。
资源推荐
资源详情
资源评论
收起资源包目录
Eclipse写的商城购物系统 (217个子文件)
connDB.class 4KB
MemberDaoImpl.class 3KB
member.class 3KB
GoodsDaoImpl.class 2KB
goods.class 2KB
SubtypeDaoImpl.class 1KB
PlacardDaoImpl.class 1KB
SuperTypeDaoImpl.class 1KB
chStr.class 1KB
SubType.class 848B
placard.class 823B
SuperType.class 639B
goodselement.class 354B
MemberDao.class 282B
GoodsDao.class 192B
SupertypeDao.class 170B
SubtypeDao.class 164B
PlacardDao.class 164B
.classpath 340B
style.css 2KB
Thumbs.db 223KB
Thumbs.db 149KB
db_shop备份 1.33MB
621.gif 124KB
center01.gif 25KB
manage_01.gif 25KB
manage_03.gif 24KB
manage_02.gif 23KB
shop_18a.gif 20KB
center_bbsdetail.gif 20KB
center_orderdetail.gif 20KB
center_searchresult.gif 20KB
center_checkout.gif 20KB
center_empty.gif 20KB
center_goodsdetail.gif 20KB
center_cart.gif 20KB
center_newgoods.gif 19KB
center_sellsort.gif 19KB
center_sale.gif 19KB
center_order.gif 19KB
manage_center_goodsdetail.gif 19KB
manage_center_goodsmodi.gif 19KB
manage_center_superAdd.gif 19KB
manage_center_subList.gif 19KB
manage_center_orderdetail.gif 19KB
manage_center_subAdd.gif 19KB
manage_center_goodsdel.gif 19KB
manage_center_superList.gif 19KB
manage_center_memberdetail.gif 19KB
manage_center_placardadd.gif 19KB
manage_center_goodsadd.gif 19KB
manage_center_memberlist.gif 19KB
manage_center_orderlist.gif 18KB
manage_center_placardlist.gif 18KB
cart.gif 18KB
center_type.gif 17KB
shop_18.gif 16KB
shop_17.gif 10KB
141.gif 9KB
ggzs.gif 8KB
shop_02.gif 6KB
shop_22.gif 5KB
shop_20.gif 4KB
shop_15.gif 2KB
shop_11.gif 2KB
shop_28.gif 2KB
shop_21.gif 2KB
T_contact.gif 1KB
T_favorite.gif 1KB
shop_03.gif 1KB
T_home.gif 1KB
shop_19.gif 1KB
shop_33.gif 1KB
contact.GIF 1KB
shop_07.gif 1KB
shop_26.gif 1KB
shop_13.gif 1KB
freeze.gif 982B
folder.gif 933B
shop_27.gif 895B
shop_16.gif 886B
manage_06.gif 864B
center02.gif 814B
shop_29.gif 653B
MORE.GIF 634B
shop_24.gif 601B
shop_09.gif 582B
enforce.gif 567B
thaw.gif 567B
shop_31.gif 469B
list.gif 367B
jia.gif 211B
jian_null.gif 209B
shop_25.gif 204B
shop_04.gif 184B
jian.gif 177B
shop_01.gif 157B
modify.gif 121B
shop_12.gif 112B
del.gif 109B
共 217 条
- 1
- 2
- 3
资源评论
- 木子希2013-11-05很好,能运行
- 6到不胜寒2013-04-11写得很好!,但是不符合我的要求
年轻大天才
- 粉丝: 3
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功