新建 文本文档.txt

般的java连接数据库的控制层代码,jsp中使用过 【

 一般的java连接数据库的控制层代码，jsp中使用过

package ecbase.db;

import java.sql.*;

/**
* Title: faq.java
* Description:
* Copyright: Copyright (c) 2005
* Company:
* @author: [e-mail]
**/

public class faq {
protected Connection conn = null;//Connection接口
protected Statement stmt = null;//Statement接口
protected ResultSet rs = null;//记录结果集
protected PreparedStatement prepstmt = null;//PreparedStatement接口
protected boolean isConnect=true;//与数据库连接标识
protected String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
protected String sConnStr="jdbc:odbc:jspshop";

public faq() {
try
{
// Class.forName(sDBDriver);
//conn=DriverManager.getConnection(sConnStr,"","");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://211.87.209.185:1433;DatabaseName=jspshop";
String user="jspshop";
String password="jspshop";
conn= DriverManager.getConnection(url,user,password);

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);

}
catch (Exception e)
{
System.out.println(e);
isConnect=false;
}

}

public Statement getStatement() {
return stmt;
}

public Connection getConnection() {
return conn;
}

public PreparedStatement getPreparedStatement(String str) {
try {
prepstmt = conn.prepareStatement(str);
return prepstmt;
} catch (SQLException ex) {
ex.printStackTrace();
return null;
}
}

public ResultSet executeQuery(String str) {
try {
/////////为了形成多个数据集，使用到这方法。
Statement stmt1;
stmt1 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs = stmt1.executeQuery(str);
return rs;
} catch (SQLException ex) {
return null;
}

}


public void executeInsert(String str) throws Exception {
stmt.executeUpdate(str);
}

public int executeUpdate(String str) throws Exception {
return stmt.executeUpdate(str);
}

public void executeDelete(String str) throws Exception {
stmt.execute(str);
}

public void Close() throws SQLException {
if ( stmt != null )
{
stmt.close();
stmt = null;
}
conn.close();
conn = null;
}

public void close() throws SQLException {
if ( stmt != null )
{
stmt.close();
stmt = null;
}
conn.close();
conn = null;
}