src/t/o/bean/DBmessage.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package t.o.bean;

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

public class DBmessage {
	private static String dbDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static String dbUrl="jdbc:sqlserver://localhost:1433;DatabaseName=OrderfoodSystem";
	private static String dbuser = "sa";
	private static String dbpwd = "sa";

	public static Connection getConnection(){
		Connection conn = null;
		try {
			Class.forName(dbDriver);
			conn = DriverManager.getConnection(dbUrl,dbuser,dbpwd);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		if (conn == null) 
		{
			System.err.println("警告:数据库连接失败!");
		}
		return conn;	
	}
	public static void allClose(Connection conn,Statement stmt,ResultSet rs){
			try {
				if(conn!=null){
					conn.close();
					conn=null;
				}
				if(stmt!=null){
					stmt.close();
					stmt = null;
				}
				if(rs!=null){
					rs.close();
					rs = null;
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	}
}