请问在jsp中应该将Javabean放在何处!
hhl00 2003-09-18 08:46:21 在论坛找了半天,还是没有解决,只能发问了。我的配置环境是Apache+resin+MySQL,经过测试,完全可以与数据库连接,一切均正常。现在使用JavaBean,已经将其写好,代码如下:
package mysqlcommand;
import java.sql.*;
public class sql_data
{
String sDBDriver="com.mysql.jdbc.Driver";
String sConnStr="jdbc:mysql://localhost/data?user=dbuser&password=192168&useUnicode=true&characterEncoding=gb2312";
Connection conn=null;
ResultSet rs=null;
public sql_data()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("sql_data():"+e.getMessage());
}
}
public void executeInsert(String sql)
{
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeUpdate:"+ex.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeDelete(String sql)
{
try
{
conn=DriverManager.getConnection(sConnStr);
Statement stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("sql_data.executeDelete:"+ex.getMessage());
}
}
}
调用页面如下:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id="sqlbean" class="mysqlcommand.sql_data" scope="page" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>check</title>
</head>
<body>
<%
String name=request.getParameter("name");
String passwd=request.getParameter("passwd");
String sqlInsert="insert into student(name,user_id) values('"+name+"','"+passwd+"')";
ResultSet rsLogin=sqlBean.executeInsert(sqlInsert);
%>
</body>
</html>
现在的问题是:
1)上面的调用代码对吗?
2)创建的JavaBean文件需要用javac先编译吗
2)我的JavaBean文件要放在哪里?