dbconnection.java

来自「新闻发布系统 jsp制作。可应用与毕业设计」· Java 代码 · 共 54 行

package com.newsIssueSystem.javaBean;

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



public class DBConnection {
	public java.sql.Connection con;
	public Statement sta;
	public ResultSet rs;
	public PreparedStatement presta;
	/*
	 *得到一个连接
	 * */
	public Connection getCon()
	{
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=newsDB","sa","");
			sta=con.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return con;
	}
	
	/*
	 * 关闭连接
	 * */
	public void closeCon()
	{
		try {
			sta.close();
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}