使用javabean的一些小问题
各位大虾:
我做的关于数据库操作的javabean:
package test;
import java.sql.*;
import java.io.*;
import java.lang.*;
public class DbSql
{
String sDBDriver = "COM.ibm.db2.jdbc.net.DB2Driver";
String sConnStr = "jdbc:db2://202.117.106.64:5000/xuebao";
String sUser = "db2inst1";
String sPassword = "db2inst1";
Connection conn = null;
ResultSet rs = null;
public DbSql()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("DbSql(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr,sUser,sPassword);
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("DbSql.executeQuery:"+ex.getMessage());
}
return rs;
}
public void executeInsert(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,sUser,sPassword);
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.executeUpdate();
}
catch(SQLException ex)
{
System.err.println("DbSql.executeUpdate:"+ex.getMessage());
}
}
public void executeDelete(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,sUser,sPassword);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("DbSql.executeUpdate:"+ex.getMessage());
}
}
public void executeUpdate(String sql)
{
try
{
conn = DriverManager.getConnection(sConnStr,sUser,sPassword);
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println("DbSql.executeUpdate:"+ex.getMessage());
}
}
}
在jsp中使用的时候用于一般的关于英文的查询,更新操作都是成功的,所谓关于英文的意思是传递的变量值是英文符号,但是只要中间有中文符号就不对了,比如说牵扯到中文用户名的查询之类的,系统就不会执行数据库操作。这到底是什么原因阿?
我的数据库是db2,我在主级上用sql语句可以插入查询中文,是怎么回事啊?
很急!!!!!