关于jsp页面的更新与查询!!!
在一张jsp页面中,要同时执行更新和查询两个操作,若单单查询,没有问题,如果我先进行更新,然后再查询,页面就无法显示(页面进度条缓慢进行,最终也没显示出来),也不提示任何错误!(但如果我直接在java类中的main函数进行更新和查询,缺没有任何问题).
各位大虾相助,都搞一个星期了~~555
以下是连接数据库的类:
-----------------------------------
package com.matrix.mail;
import java.sql.*;
import java.util.Properties;
import java.io.*;
public class DBConn
{
String dbDriver= " ";
String url= " ";
String userName= " ";
String password= " ";
//String sDBDriver= "net.sourceforge.jtds.jdbc.Driver ";
//String sConnStr= "jdbc:jtds:sqlserver://192.168.150.190:1433/guestbook ";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
public DBConn()
{
InputStream is = getClass().getResourceAsStream( "db.properties ");
Properties dbProps = new Properties();
try {
dbProps.load(is);
} catch (Exception e) {
System.err.println( "Can 't read the properties file. "
+ "Make sure db.properties is in the CLASSPATH ");
}
dbDriver=dbProps.getProperty( "dbDriver_jtds ");
url = dbProps.getProperty( "url_jtds ");
userName = dbProps.getProperty( "userName ");
password = dbProps.getProperty( "password ");
try
{//注册数据库驱动程序
Class.forName(dbDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println(e.getMessage());
}
}
//建立数据库连接及定义数据查询
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
//创建数据库联接对象
conn=DriverManager.getConnection(url,userName,password);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println( "aq.executeQuery: "+ex.getMessage());
}
return rs;
}
//定义数据操作
public void executeUpdate(String sql)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(url,userName,password);//创建数据库联接对象
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
stmt.executeUpdate(sql);
}
catch(SQLException ee)
{
System.err.println( "aq.executeUpdate: "+ee.getMessage());
}
}
public PreparedStatement getPreparedStatement(String sql)
{
PreparedStatement ps=null;
try{
conn=DriverManager.getConnection(url,userName,password);
ps=conn.prepareStatement(sql);
return ps;
}catch(SQLException ee)
{
dispose(ps);
ee.printStackTrace();
return null;
}
}
//关闭Statement
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
//关闭连接
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static int dispose(Statement st)
{
if(st == null)
return 0;
try
{
disposeStatement(st);
}
catch(Exception exception) { }
return 0;
}
private static int disposeStatement(Statement st)
{
if(st == null)
return 0;
try
{
st.close();
return 0;
}
catch(Exception exception)
{
return -1;
}
}
public static void main(String arg[])
{
}
}
[解决办法]
jsp文件里面是怎么操作的
[解决办法]
你的页面是怎么调用的，也贴出来
[解决办法]
更新完后关闭下st
