dbconnection.java

新闻发布系统

package com.DB;

import java.sql.*;

public class DBConnection 
{
	public Connection con;
	public Statement st;
	public ResultSet rs;
	public PreparedStatement ps;
	
	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=news","sa","");
			st=con.createStatement();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		}
		return con;
	}
}