cn.java

JSP javaBean 数据库无限级动态树状菜单

package com.netmarch.folder;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Cn {
	String jdbcDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

	//jdbc驱动

	String connectionString = "jdbc:microsoft:sqlserver://192.168.1.171:1433;DatabaseName=zgwj_jsp";

	//数据库连接字符串

	String user = "ksgov";

	//数据库用户名

	String pass = "ksgov";

	//数据库密码

	Connection conn = null;

	ResultSet rs = null;

	public Cn() {
		try {
			Class.forName(jdbcDriver);
		} catch (ClassNotFoundException e) {
			System.err.println(e.toString());
		}
	}

	public ResultSet executeQuery(String sql) {
		rs = null;
		try {
			conn = DriverManager.getConnection(connectionString, user, pass);
			Statement stmt = conn
					.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
							ResultSet.CONCUR_UPDATABLE);
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			System.err.println(e.toString());
		}
		return rs;
	}

	public void executeUpdate(String sql) {
		try {
			conn = DriverManager.getConnection(connectionString, user, pass);
			Statement stmt = conn
					.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
							ResultSet.CONCUR_UPDATABLE);
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			System.err.println(e.toString());
		}
	}
}