＋设为首页 ＋添加到收藏夹
在论坛找了半天，还是没有解决，只能发问了。我的配置环境是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文件要放在哪里？
2、要
3、\WEB-INF\classes\ 目录下
<jsp:useBean id="sqlbean" class="mysqlcommand.sql_data" scope="page" />
ResultSet rsLogin=sqlBean.executeInsert(sqlInsert);
sqlBean：注意区分大小写
