package lxh.dbc;
import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection {
private static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
private static final String DBURL = "jdbc:mysql://lochost:3306/mldn";
private static final String DBUSER = "root";
private static final String DBPASSWORD="mysqladmin";
private Connection conn=null;
public Connection getConntion(){
return this.conn;
}
public void close(){
if(conn!=null){
try{
conn.close();
}catch(Exception e){
System.out.print(e);
}
}
}
}
<%@ page language="java" contentType="text/html"
pageEncoding="utf-8"%>
<jsp:useBean id="database"Class="lxh.dbc*">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h2><%=database.getConntion()%></h2>
</body>
</html>在jsp中调用 出现错误
import java.sql.Connection;
import java.sql.DriverManager;
public class DatabaseConnection {
private static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
private static final String DBURL = "jdbc:mysql://lochost:3306/mldn";
private static final String DBUSER = "root";
private static final String DBPASSWORD="mysqladmin";
private Connection conn=null;
public Connection getConntion(){
return this.conn;
}
public void close(){
if(conn!=null){
try{
conn.close();
}catch(Exception e){
System.out.print(e);
}
}
}
}
<%@ page language="java" contentType="text/html"
pageEncoding="utf-8"%>
<jsp:useBean id="database"Class="lxh.dbc*">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h2><%=database.getConntion()%></h2>
</body>
</html>在jsp中调用 出现错误
Class.forName(DBDRIVER);
Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
return conn;
}试一下。
public Connection getConntion(){
return this.conn;
}
你返回的那个Connection对象都没有实例化,直接去调用肯定出错,使用楼上的那段程序:
public Connection getConntion(){
Class.forName(DBDRIVER);
Connection conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
return conn;
}
试试应该就可以