src/dao/CommDAO.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

package dao;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Properties;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import util.Info;


public class CommDAO
{
	public static String dbname = "";
	public static String dbtype = "";
	
	public static Connection conn = null;
	
	public CommDAO()
	{
		conn = this.getConn();
	}

	public Connection getConn()
		{
		        try
		        { 
		        	if(conn==null||conn.isClosed()){
		        		
		        		// Class.forName("com.mysql.jdbc.Driver");
			        	// conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/javatemp","root","");
						 
						 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			        	 conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=jspmbysjyxxgl5810","sa","sa123456");
		            }}
		        catch(Exception e)
		        {
		            e.printStackTrace();
		        }
		        return conn;
		}