DBC代码/**
* 数据库连接
*/
package dbcon;import java.sql.*;/**
* @author Administrator
*
*/
public class DBConnect { // 驱动
private static final String DRIVERCLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 连接
// public final static String DBURL =
// "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=master";
protected final String DBURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=txl"; // 数据库用户
public final static String DBUSER = "sa"; // 密码
public final static String USERPWD = "1111"; // 连接
public Connection conn; // SQL 执行器
public Statement stmt; // 结果集
public ResultSet rs;
// 静态块,只加载一次
static {
// 加载驱动
try { Class.forName(DRIVERCLASS); } catch (ClassNotFoundException e) { // 加载驱动异常
System.out.println("加载驱动异常");
e.printStackTrace();
}
} /**
* 打开连接
*
*/
public boolean openConn() {
boolean isOpen = true;
try {
conn = DriverManager.getConnection(DBURL, DBUSER, USERPWD);
System.out.println("数据库连接ok");
stmt=conn.createStatement();
} catch (SQLException e) {
isOpen = false;
System.out.println("数据库连接异常");
e.printStackTrace();
}
return isOpen;
} /**
* 打开连接
*
*/
public boolean closeConn() {
boolean isOpen = true;
try {
conn.close();
} catch (SQLException e) {
isOpen = false;
System.out.println("数据库连接异常");
e.printStackTrace();
}
return isOpen;
} /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DBConnect a = new DBConnect();
a.openConn();
}}
错误提示:TDSConnection.<init>(String, String, BaseExceptions) line: not available
SQLServerImplConnection.open() line: not available [local variables unavailable]
SQLServerConnection(BaseConnection).getNewImplConnection(boolean, int) line: not available
SQLServerConnection(BaseConnection).open(BaseConnectionProperties, BaseExceptions) line: not available
SQLServerDriver(BaseDriver).connect(String, Properties) line: not available
DriverManager.getConnection(String, Properties, ClassLoader) line: not available
DriverManager.getConnection(String, String, String) line: not available
DBoprate(DBConnect).openConn() line: 58
login.jsp line: 16
login_jsp(Htlogin_jsp(HttpServlet).service(ServletRequest, ServletResponse) line: 729
tpJspBase).service(HttpServletRequest, HttpServletResponse) line: 98
JspServletWrapper.service(HttpServletRequest, HttpServletResponse, boolean) line: 331
JspServlet.serviceJspFile(HttpServletRequest, HttpServletResponse, String, Throwable, boolean) line: 329
JJspServlet(HttpServlet).service(ServletRequest, ServletResponse) line: 729
spServlet.service(HttpServletRequest, HttpServletResponse) line: 265
ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 269
ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 188 各位大侠救救我啊
* 数据库连接
*/
package dbcon;import java.sql.*;/**
* @author Administrator
*
*/
public class DBConnect { // 驱动
private static final String DRIVERCLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; // 连接
// public final static String DBURL =
// "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=master";
protected final String DBURL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=txl"; // 数据库用户
public final static String DBUSER = "sa"; // 密码
public final static String USERPWD = "1111"; // 连接
public Connection conn; // SQL 执行器
public Statement stmt; // 结果集
public ResultSet rs;
// 静态块,只加载一次
static {
// 加载驱动
try { Class.forName(DRIVERCLASS); } catch (ClassNotFoundException e) { // 加载驱动异常
System.out.println("加载驱动异常");
e.printStackTrace();
}
} /**
* 打开连接
*
*/
public boolean openConn() {
boolean isOpen = true;
try {
conn = DriverManager.getConnection(DBURL, DBUSER, USERPWD);
System.out.println("数据库连接ok");
stmt=conn.createStatement();
} catch (SQLException e) {
isOpen = false;
System.out.println("数据库连接异常");
e.printStackTrace();
}
return isOpen;
} /**
* 打开连接
*
*/
public boolean closeConn() {
boolean isOpen = true;
try {
conn.close();
} catch (SQLException e) {
isOpen = false;
System.out.println("数据库连接异常");
e.printStackTrace();
}
return isOpen;
} /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
DBConnect a = new DBConnect();
a.openConn();
}}
错误提示:TDSConnection.<init>(String, String, BaseExceptions) line: not available
SQLServerImplConnection.open() line: not available [local variables unavailable]
SQLServerConnection(BaseConnection).getNewImplConnection(boolean, int) line: not available
SQLServerConnection(BaseConnection).open(BaseConnectionProperties, BaseExceptions) line: not available
SQLServerDriver(BaseDriver).connect(String, Properties) line: not available
DriverManager.getConnection(String, Properties, ClassLoader) line: not available
DriverManager.getConnection(String, String, String) line: not available
DBoprate(DBConnect).openConn() line: 58
login.jsp line: 16
login_jsp(Htlogin_jsp(HttpServlet).service(ServletRequest, ServletResponse) line: 729
tpJspBase).service(HttpServletRequest, HttpServletResponse) line: 98
JspServletWrapper.service(HttpServletRequest, HttpServletResponse, boolean) line: 331
JspServlet.serviceJspFile(HttpServletRequest, HttpServletResponse, String, Throwable, boolean) line: 329
JJspServlet(HttpServlet).service(ServletRequest, ServletResponse) line: 729
spServlet.service(HttpServletRequest, HttpServletResponse) line: 265
ApplicationFilterChain.internalDoFilter(ServletRequest, ServletResponse) line: 269
ApplicationFilterChain.doFilter(ServletRequest, ServletResponse) line: 188 各位大侠救救我啊
解决方案 »
- spring3.1.1中aspectj注解的应用
- 数据库分页查询赋值
- spring + hibernate 在没有配置事务的情况下,为什么能够删除?
- jsp页面如何显示指定得excel
- 刚开始学习Struts,请问有没有比较好的JSP编辑工具,支持Struts的标记。
- 一个关于 〈c:forEach〉</c:forEach>问题,急!在线等
- cookie问题!第一次进入报错!
- 为什么我的第一个Session ejb 不能部署?
- 一个小小的时间问题进来看看。
- 关于springboot中Controller调整到JSP的问题
- 插入记录问题
- 在jsp 页面中,采取javascript提示错误信息,但是页面弹不出提示信息 请帮忙
还有就是SQL没打补丁
查询 下版本是不是在8.0.760 以上
如果不是就说明补丁没有打好我有补丁,如果你还不知道怎么搞就加我QQ,我帮你搞定 119066075