- 论坛徽章:
- 0
|
我的連接數據庫的JAVA文件如下﹐請高手幫我分析一下﹕
package com;
import java.io.PrintStream;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
public class conn1
{
String sDBDriver;
String url;
String user;
String password;
Connection conn;
Statement stmt;
ResultSet rs;
public conn1()
{
sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
url = "jdbc:microsoft:sqlserver://10.99.60.82:1433;DatabaseName=pdm";
user = "sa";
password = "pdmsa";
conn = null;
stmt = null;
rs = null;
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("connect false(): " + classnotfoundexception.getMessage());
}
}
public Connection conn()
{
try
{
conn = DriverManager.getConnection(url, user, password);
}
catch(Exception exception)
{
System.err.println("connect false(): " + exception.getMessage());
}
return conn;
}
public ResultSet executeQuery(String s) //數據查詢用的代碼
{
try
{
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(1004, 100 ;
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println("executeQuery False():" + sqlexception.getMessage());
}
return rs;
}
}
我在jsp中調用格式如下﹕
.....
<jsp:useBean id="conn1" scope="page" class="com.conn1"/>
....
<html>
<head>....</head>
<body>
<%
.....
String xm="";
String str1="select xm from user_id";
ResultSet rs1=conn1.executQuery(str1);
if(rs1.next())
xm=rs1.getString("xm" ;
rs1.close(); //此句有時沒寫﹐但我即使寫上﹐好像也沒有效果
....
%>
</body>
</html>
請高手幫我分析一下為何會讓sql server 2000(sp3)占用內存不斷增加﹗ |
|
免费注册
发表于 2006-03-06 12:34
