src/com/util/db.java

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

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

package com.util;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.List;
import java.util.Random;
import java.util.HashMap;

import java.sql.SQLException;
import org.apache.struts2.ServletActionContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import com.util.Constant;


public class db {
	 //private String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	// private String sConnStr = "jdbc:microsoft:sqlserver://localhost:1433;databasename=ssmqczlzcxxthsg5886AHB7"; 
	 
	 private String dbDriver="com.mysql.jdbc.Driver";
	 private String sConnStr = "jdbc:mysql://localhost:3306/ssmqczlzcxxthsg5886AHB7?useUnicode=true&characterEncoding=gb2312"; 
	
	 // private String dbDriver="net.sourceforge.jtds.jdbc.Driver";
	// private String sConnStr = "jdbc:jtds:sqlserver://127.0.0.1:1433;databaseName=ssmqczlzcxxthsg5886AHB7"; 
	 
	
	 private String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
	 private List list;
	  public Connection connect = null;
	  public ResultSet rs=null;
	  public String nsa="root";
	  public String nmm="";
	  public db() {
	    try {
	     
	      Class.forName(dbDriver).newInstance(); 
	    }
	    catch (Exception ex) {
	      System.out.println("12121");
	    }
	  }
	
	  
	  public ResultSet executeQuery(String sql) {
			try{
				connect=DriverManager.getConnection(sConnStr,nsa,nmm);
				Statement stmt=connect.createStatement();
				rs=stmt.executeQuery(sql);
			}catch(SQLException ex){
				System.err.println(ex.getMessage());
			}
			return rs;
		}
	  
	  
	  public String hsggetoption(String ntable,String nzd){
			StringBuffer imgStr = new StringBuffer();
			imgStr.append("");