dbconn.java

来自「MIS系统 大学MIS课程设计相关内容 属于样板。MIS系统 大学MIS课程设计」· Java 代码 · 共 57 行

package db;

import java.sql.*;

public class dbConn
{
	String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=YouBangDB";
	String user = "sa";
	String password = "admin";
	Connection conn = null;
	ResultSet rs = null;
	int result;
	//
	public dbConn()
	{
		try
		{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e)
		{
			System.err.println(e.getMessage());
		}
		
	}
	//询侄渭询
	public ResultSet executeQuery(String sql)
	{
		try
		{
			conn = DriverManager.getConnection(sConnStr,user,password);
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);	
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	//莸姆
	/*public int executeUpdate(String sql)
	{
		try
		{
			conn = DriverManager.getConnection(sConnStr,user,password);
			Statement stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		}
		catch(SQLException ex)
		{
			System.err.println(ex.getMessage());	
		}
		return result;
	}*/
}