今晚编写了一个javabean程序想链接jsp与MySQL数据库,但是出现了问题我在dreamweaver中用f12运行testBean的时候tomcat都会很奇怪的停止服务.即本来tomcat是开启的,但是在按下f12之后toncat服务器就关闭了.其它的jsp页面则可以正常显示.
在这里恳请大家的帮助,谢谢大家!
javabean的代码如下:
package test.db;
import java.io.*;
import java.sql.*;
public class DatabaseCon {
public Connection con;
public String dbDriver="org.gjt.mm.mysql.Driver";
public String URL = "jdbc:mysql://localhost/tcpl";
public String Message;
public boolean connection() {
try{
Class.forName("dbDriver");
}
catch(ClassNotFoundException ex){
Message=ex.getMessage();
System.exit(-1);
}
try{
con = DriverManager.getConnection(URL,"root","1");
return true;
}
catch(SQLException ex){
Message=ex.getMessage();
return false;
}
}
public boolean close(){
try{
con.close();
return true;
}
catch(Exception ex){
Message=ex.getMessage();
return false;
}
}
public ResultSet exeSQL(String sqlstr) {
try{
connection();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sqlstr);
return rs;
} catch(Exception ex){
Message=ex.getMessage();
}
return null;
}
public String getString(ResultSet rs,String str){
try{
return rs.getString(str);
}catch(Exception ex){
Message=ex.getMessage();
}
return null;
}
}
testBean.jsp的代码如下
<%@ page contentType="text/html; charset=GB2312" import="java.sql.*" %>
<html>
<head>
<title>
测试数据库连接Bean
</title>
</head>
<jsp:useBean id="dbBean" scope="session" class="test.db.DatabaseCon" />
<body bgcolor="#ffffff">
<%
ResultSet rs=dbBean.exeSQL("select * from tushumingxi");
String str;
try{
while(rs.next()){
str=dbBean.getString(rs,"banshe");%>
【<%=dbBean.getString(rs,"shu_name")%>】 -> <%=str%><br>
<%
}}catch(Exception ex){
out.print(ex.getMessage());
}
%>
</body>
</html>
再次感谢大家的帮助.新手刚刚上路,请大家多多关照~~`
在这里恳请大家的帮助,谢谢大家!
javabean的代码如下:
package test.db;
import java.io.*;
import java.sql.*;
public class DatabaseCon {
public Connection con;
public String dbDriver="org.gjt.mm.mysql.Driver";
public String URL = "jdbc:mysql://localhost/tcpl";
public String Message;
public boolean connection() {
try{
Class.forName("dbDriver");
}
catch(ClassNotFoundException ex){
Message=ex.getMessage();
System.exit(-1);
}
try{
con = DriverManager.getConnection(URL,"root","1");
return true;
}
catch(SQLException ex){
Message=ex.getMessage();
return false;
}
}
public boolean close(){
try{
con.close();
return true;
}
catch(Exception ex){
Message=ex.getMessage();
return false;
}
}
public ResultSet exeSQL(String sqlstr) {
try{
connection();
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(sqlstr);
return rs;
} catch(Exception ex){
Message=ex.getMessage();
}
return null;
}
public String getString(ResultSet rs,String str){
try{
return rs.getString(str);
}catch(Exception ex){
Message=ex.getMessage();
}
return null;
}
}
testBean.jsp的代码如下
<%@ page contentType="text/html; charset=GB2312" import="java.sql.*" %>
<html>
<head>
<title>
测试数据库连接Bean
</title>
</head>
<jsp:useBean id="dbBean" scope="session" class="test.db.DatabaseCon" />
<body bgcolor="#ffffff">
<%
ResultSet rs=dbBean.exeSQL("select * from tushumingxi");
String str;
try{
while(rs.next()){
str=dbBean.getString(rs,"banshe");%>
【<%=dbBean.getString(rs,"shu_name")%>】 -> <%=str%><br>
<%
}}catch(Exception ex){
out.print(ex.getMessage());
}
%>
</body>
</html>
再次感谢大家的帮助.新手刚刚上路,请大家多多关照~~`
public class ConnDB {
我这连接串是sql的改成mysql
public static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
public static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=UsersDB";
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(DRIVER);
conn = DriverManager.getConnection(URL,"sa","123");
} catch (Exception e) {
// TODO: handle exception
}
return conn;
}
//关闭链接
public static void close(ResultSet rs,Statement st,Connection conn){
try {
if(rs != null){
rs.close();
}
if(st != null){
st.close();
}
if(conn != null){
conn.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}