src/com/office/dao/DB.java

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

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

package com.office.dao;

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

import com.office.actionform.AdviceForm;
import com.office.actionform.FileForm;
import com.office.actionform.MailForm;
import com.office.actionform.MeetForm;
import com.office.actionform.MoneyCarForm;
import com.office.actionform.MoneyThingForm;
import com.office.actionform.PcardForm;
import com.office.actionform.TextForm;
import com.office.actionform.UserForm;
import com.office.officemenu.MenuSigle;

public class DB {
    private ResultSet rs;
    private Statement stm;
    private Connection con;
    private String url=Content.URL;
    private String classname=Content.CLASSNAME;
    private int num_per=0;
    private int num_rs=0;
    private int num_currentpage=1;
    private int num_pages=1;
    public DB(){
    	try{
    		Class.forName(classname);
    	}
    	catch(ClassNotFoundException e){
    		e.printStackTrace();
    	}
    }
    
    public Connection getCon(){    	  
    	  try{
    	      con=DriverManager.getConnection(url,"sa","sa");
    	  }catch(Exception e){e.printStackTrace(System.err);}
    	  return con;
    }
    public Statement getStm(){
    	  try{
    	     con=getCon();
    	     stm=con.createStatement();
    	  }catch(Exception e){e.printStackTrace(System.err);}
    	   return stm;
    	 }
    	 public Statement getStmed(){
    	  try{
    	     con=getCon();
    	     stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
    	  }catch(Exception e){e.printStackTrace(System.err);}
    	  return stm;
    }