package shopping;
import java.sql.*;public class ConnecteDB {
private Connection ct=null; public Connection getConn(){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb2"
,"sa","");
}
catch (Exception ex) {
ex.printStackTrace();
} return ct;
}}
import java.sql.*;public class ConnecteDB {
private Connection ct=null; public Connection getConn(){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=spdb2"
,"sa","");
}
catch (Exception ex) {
ex.printStackTrace();
} return ct;
}}
解决方案 »
- 关于springSecurity的问题,求指教啊
- try中有retrun,finaly是在retrun执行之前执行还是之后?
- 使用jQuery简化Ajax 开发
- 如何用js获取table第1行第2列的值!
- tomcat6 已服务形式启动,在与文件交互时出现乱码?正常启动startup.bat时,不会出现这样问题?请高手帮解决。在线等!十万火急
- 如何使用 JPCAP包
- 为什么Tomcat5.0开一段时间后会自动退出服务
- 跪求Jqplot报表问题
- javamail中不能得到folder中的message[]?
- Postman绕不过通过cookie的记住登录的JSP界面
- 征求计费管理系统
- 高分请教,哪位前辈有使用tomcat5.5在64位的windows2003运行
mssqlserver.jar
msbase.jar
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en
安装后就能够获得msbase.jar、mssqlserver.jar、msutil.jar三个jar包。连接代码可参考下面的
package com.chinadim.ivr.wt_yzqj;import java.io.InputStream;
import java.sql.*;
import java.util.Properties; public class Oracle {
private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名";
private String userName = 用户名; private String userPwd = 密码;
private Connection dbConn = null; private PreparedStatement prepstmt = null;
private CallableStatement callstmt = null; private ResultSet rs = null; private boolean stmtType = false;
// public static void main(String[] args)
// {
// String sql = "select * from test_week_info";
// SQLServer server = SQLServer.getInstance(sql);
// Connection conn = server.getConn();
// ResultSet rs = null;
// try{
// Statement s = conn.createStatement();
// rs = s.executeQuery(sql);
// }catch(Exception e){e.printStackTrace();}
// //ResultSet rs = server.executeQuery();
// try {
// while (rs.next()) {
// System.out.println(rs.getString(1)+" ");
// //+rs.getInt(2)+" "
// //+rs.getInt(3));
// //+rs.getString(4)+" "
// //+rs.getString(5));
// }
//
// } catch (SQLException e) {
//
// e.printStackTrace();
//
// } finally {
//
// server.close();
//
// }
//
// }
/**
*获取个数据库连接
*/
public static Oracle getInstance(String sql) {
return new Oracle(sql);
}
/**
*构? */
public Oracle(String sql) {
try {
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!"); String[] ss = sql.split(" ");
stmtType = ss[0].equalsIgnoreCase("exec");
if (stmtType) {
//调用存储过程
callstmt = dbConn.prepareCall(sql); }
else {
//执行预处??? 的sql语句
prepstmt = dbConn.prepareStatement(sql,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
}
} catch (Exception e) {
e.printStackTrace();
}
} public Connection getConn()
{
return dbConn;
}
/**
*执行数据库的存储过程操作
*/
public boolean execute() {
boolean b = false;
try {
if (stmtType) { b = callstmt.execute(); } else { b = prepstmt.execute(); } } catch (SQLException e) {
e.printStackTrace();
}
return b;
}
/**
*执行数据库的查询操作,???般用于select语句
*/
public ResultSet executeQuery() { try {
rs = prepstmt.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
/**
*执行数据库的更新操作,???般用于update,insert???
*/
public int executeUpdate() {
int row = -1;
try {
row = prepstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return row;
}
/**
*预处理sql语句setInt函数
*/
public void setInt(int index, int value) {
try {
if (stmtType) { callstmt.setInt(index, value); }
else { prepstmt.setInt(index, value); }
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
*预处理sql语句setString函数
*/
public void setString(int index, String value) {
try {
if (stmtType) { callstmt.setString(index, value); }
else { prepstmt.setString(index, value); }
}
catch (SQLException e) {
e.printStackTrace();
}
} public String getCallStatment()
{
return callstmt.toString();
} public void close() {
try {
if (rs != null) {
rs.close();
}
if (prepstmt != null) {
prepstmt.close();
}
if (dbConn != null) {
dbConn.close();
}
}
catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 同stmt.setTimestamp(int i,Timestamp j) * @param index 索引 * @param value 值 */ public void setTimestamp(int index, java.sql.Timestamp value) { try { if (stmtType) { callstmt.setTimestamp(index, value); }
else { prepstmt.setTimestamp(index, value); } }
catch (SQLException e) { e.printStackTrace(); } }
}