db.java

这是一个用JSP和SQL Server实现的一个网络办公自动化系统.里面包括所有需要用到的源代码.

/*
 * Created on 2004-9-18
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package oa.sys;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
/**
 ****************************************************
 *绫诲悕绉帮細	Db<br>
 *绫诲姛鑳斤細	鏁版嵁搴撴搷浣\uFFFD<br>
 *鍒涘缓锛\uFFFD鐧戒紵鏄\uFFFD2004骞\uFFFD鏈\uFFFD3鏃\uFFFDbr>
 ****************************************************
 * To change the template for this generated type comment go to
 * Window&gt;Preferences&gt;Java&gt;Code Generation&gt;Code and Comments
 */
public class Db {
	private Connection con;
	private Statement stmt;
	private ResultSet rs;
	private PreparedStatement pstmt;
	public static int error=0;

	/***************************************************
	*鍑芥暟鍚嶇О锛\uFFFDgetCon()<br>
	*鍑芥暟鍔熻兘锛\uFFFD鑾峰彇鏁版嵁搴撹繛鎺\uFFFDbr>
	*杩斿洖鍊硷細  	鏃\uFFFDbr>
	*鍙傛暟璇存槑锛\uFFFD鏃\uFFFDbr>
	*鍒涘缓锛\uFFFD	鐧戒紵鏄\uFFFD2004骞\uFFFD鏈\uFFFD2鏃\uFFFD
	****************************************************/
	public static synchronized Connection getCon()throws Exception{
		Context ctx;
		DataSource ds;
		try{
			ctx = new InitialContext();
			ds = (DataSource)ctx.lookup("java:comp/env/jdbc/OA");
			System.err.println();
			System.err.println("鏁版嵁杩炴帴+"+(++error));
			return ds.getConnection();
		}catch(SQLException e){
			System.out.print(e);
			throw e;
		}
		catch(NamingException e){
			System.out.print(e);
			throw e;
		}
	}
	/***************************************************
	*鍑芥暟鍚嶇О锛\uFFFDgetStmtread()<br>
	*鍑芥暟鍔熻兘锛\uFFFD鑾峰彇鏁版嵁搴撻泦鍚\uFFFDbr>
	*杩斿洖鍊硷細  	Statement
	*			stmt:杩斿洖鏁版嵁搴撻泦鍚堝彧鐢ㄤ簬SELECT璇