dbconnection.java

来自「基于JAVA新闻发部系统」· Java 代码 · 共 43 行

package com.mybean;

import java.sql.*;

public class DBConnection {
	public 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();
			return null;
		}
		try {
			con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=NewsIssue","sa","");
			sta=con.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return con;
	}
	public void close()
	{
		try {
			
			sta.close();
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}