sqlsever数据库的连接 连接数据库时,有三个数据包 msdata.jar mssqlsever.jar msutik.jar 在myeclipse中是自动生成的吗,吗 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 myeclipse为了你连接数据库给你添加上的吧 那几个是sqlserver2000的驱动,2005和2008用sqljdbc.jar... 那几个是sqlserver2000的驱动,2005和2008用sqljdbc.jar... jdbc驱动包是要自己加进去的哦,每种数据库都有自己相应的驱动包 用 Hibernate 生成就可以了 给你个好东西至于驱动你自己到网上去下载咯以下是代码--------------------------------------------------------------------------------------------------------------------package com.utils;/** * @author HJ */import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.Properties;import org.apache.tomcat.dbcp.dbcp.BasicDataSource;import org.apache.tomcat.dbcp.dbcp.ConnectionFactory;import org.apache.tomcat.dbcp.dbcp.DataSourceConnectionFactory;public class DBUtil { public static String uname = null; public static String upass = null; public static String driver = null; public static String url; public static Connection con = null; public static PreparedStatement ps = null; public static ResultSet rs = null; private static BasicDataSource bds = null; private static ConnectionFactory cf = null; static { try { init(); bds = new BasicDataSource(); bds.setUsername(uname); bds.setPassword(upass); bds.setDriverClassName(driver); bds.setUrl(url); cf = new DataSourceConnectionFactory(bds); //System.out.println("2"); } catch (Exception e) { System.out.println("数据连接池异常" + e.getMessage()); } } public static Connection getConnection() { Connection con = null; try { con = cf.createConnection(); //System.out.println("3"); } catch (Exception e) { System.out.println("初始化数据连接" + e.getMessage()); } return con; } public static void CloseAll(Connection con, PreparedStatement ps, ResultSet rs) { try { if (con != null) { con.close(); } } catch (Exception e) { System.out.println("数据关闭出错" + e.getMessage()); } } // 初始化数据库连接信息 public static void init() { Properties p = new Properties(); try { p.load(DBUtil.class.getClassLoader().getResourceAsStream( "config.properties")); uname = p.getProperty("user"); upass = p.getProperty("pass"); driver = p.getProperty("driver"); url = p.getProperty("url"); //System.out.println("1"); } catch (Exception e) { System.out.println("读取配置文件出错" + e.getMessage()); } } // 通用的增册改 public static int excuSQL(String sql, Object[] obj) { int rows = 0; con = getConnection(); try { ps = con.prepareStatement(sql); if (obj != null) { for (int i = 0; i < obj.length; i++) { ps.setObject(i + 1, obj[i]); } } // 执行操作 rows = ps.executeUpdate(); } catch (SQLException e) { System.out.println("通用增删改方法出错" + e.getMessage()); } finally { CloseAll(con, ps, rs); } return rows; } //通用查询方法 public static ResultSet querySQL(String sql, Object[] obj) { con = getConnection(); try { ps = con.prepareStatement(sql); if (obj != null) { for (int i = 0; i < obj.length; i++) { ps.setObject(i + 1, obj[i]); } } rs = ps.executeQuery(); //System.out.println("4"); } catch (SQLException e) { System.out.println("通用查询方法出错" + e.getMessage()); } return rs; }} 到网上下载sql2000驱动使用:放到项目的lib下 网上下载数据库驱动,在myeclipse添加进去网站项目中就行了 对吖,MySQL有MySQL的jar包哦,要自己添加的哦,Oracle也有自己的jar包哦, 菜鸟求教:JSP页面跳转问题 各位大侠,是否必须使用out.println();的方法来输出wml的标签? JSP怎样处理中文字符? jsp上传用相对路径这么写? 求助:JavaBean的配置问题 符号+在html中有对应的html吗 关于javamail的问题 谁 有 支 持 中 文 的 jspsmartupload.jar ? Jbuilder8的问题 我写的一个JSP文本留言簿。 4年java开发工作经验进深圳华为能拿多少钱一个月? 在IE8中用window.open的问题
以下是代码
--------------------------------------------------------------------------------------------------------------------
package com.utils;
/**
* @author HJ
*/
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
import org.apache.tomcat.dbcp.dbcp.ConnectionFactory;
import org.apache.tomcat.dbcp.dbcp.DataSourceConnectionFactory;public class DBUtil {
public static String uname = null;
public static String upass = null;
public static String driver = null;
public static String url;
public static Connection con = null;
public static PreparedStatement ps = null;
public static ResultSet rs = null;
private static BasicDataSource bds = null;
private static ConnectionFactory cf = null;
static {
try {
init();
bds = new BasicDataSource();
bds.setUsername(uname);
bds.setPassword(upass);
bds.setDriverClassName(driver);
bds.setUrl(url);
cf = new DataSourceConnectionFactory(bds);
//System.out.println("2");
} catch (Exception e) {
System.out.println("数据连接池异常" + e.getMessage());
}
} public static Connection getConnection() {
Connection con = null;
try {
con = cf.createConnection();
//System.out.println("3");
} catch (Exception e) {
System.out.println("初始化数据连接" + e.getMessage());
}
return con;
} public static void CloseAll(Connection con, PreparedStatement ps,
ResultSet rs) {
try {
if (con != null) {
con.close();
}
} catch (Exception e) {
System.out.println("数据关闭出错" + e.getMessage());
}
} // 初始化数据库连接信息
public static void init() {
Properties p = new Properties();
try {
p.load(DBUtil.class.getClassLoader().getResourceAsStream(
"config.properties"));
uname = p.getProperty("user");
upass = p.getProperty("pass");
driver = p.getProperty("driver");
url = p.getProperty("url");
//System.out.println("1");
} catch (Exception e) {
System.out.println("读取配置文件出错" + e.getMessage());
}
} // 通用的增册改
public static int excuSQL(String sql, Object[] obj) {
int rows = 0;
con = getConnection(); try {
ps = con.prepareStatement(sql);
if (obj != null) {
for (int i = 0; i < obj.length; i++) {
ps.setObject(i + 1, obj[i]);
}
}
// 执行操作
rows = ps.executeUpdate();
} catch (SQLException e) {
System.out.println("通用增删改方法出错" + e.getMessage());
} finally {
CloseAll(con, ps, rs);
} return rows;
}
//通用查询方法
public static ResultSet querySQL(String sql, Object[] obj) {
con = getConnection();
try {
ps = con.prepareStatement(sql); if (obj != null) {
for (int i = 0; i < obj.length; i++) {
ps.setObject(i + 1, obj[i]);
}
}
rs = ps.executeQuery();
//System.out.println("4");
} catch (SQLException e) {
System.out.println("通用查询方法出错" + e.getMessage());
}
return rs;
}}