UC知道jsp javabean 文件部署
来源：百度知道 编辑：UC知道 时间：2024/05/28 10:05:26
java程序如下
package test;
import java.sql.*;
public class sqltest {
String userName="sa";
String userPassword="sa";
Connection dbConn;
String err;
public Connection getConn()
{
try
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
dbConn = DriverManager.getConnection(url,"sa","sa");
}catch(Exception ex)
{
dbConn=null;
err=ex.toString();
System.out.println(err);
}
finally
{
System.out.println("sucess");
}
return dbConn;
}
}
jsp文件如下
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean i
package test;
import java.sql.*;
public class sqltest {
String userName="sa";
String userPassword="sa";
Connection dbConn;
String err;
public Connection getConn()
{
try
{
String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Northwind";
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
dbConn = DriverManager.getConnection(url,"sa","sa");
}catch(Exception ex)
{
dbConn=null;
err=ex.toString();
System.out.println(err);
}
finally
{
System.out.println("sucess");
}
return dbConn;
}
}
jsp文件如下
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean i
取出来才有问题了- -#
jsp文件如下
<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*"%>
<%@page import="test.sqltest"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JDBC连接数据库实例</title>
</head>
<body>
<h1 align="center">JDBC连接数据库实例</h1>
<%
//获取数据库连接对象
Connection db;
sqltest sql = new sqltest();
db =sql.getConn();
out.println(dbCon);
out.println("sdads");
if(db != null)
{
out.println("<p ali