frmsfxmdb.java

很全面的包括了住院管理的各项功能。如：管理员登录

package db.FrmSFXMDb;

import java.sql.*;

public class FrmSFXMDb {
	private	String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//驱动字符串
	private	String dbConnStr = "jdbc:odbc:Dbserver";//连接字符串
	private	Connection conn;	//连接对象
    private Statement stmt;   		//JDBC声明 
    private String psSQL = null;
    private String[] preSQL;
    
    public ResultSet prs;
 
    public boolean getConnection()
	{
		try
		{
				Class.forName(dbDriver);
				conn = DriverManager.getConnection(dbConnStr);
				//设置不自动提交
				conn.setAutoCommit(false);
				stmt = conn.createStatement();
		}
		catch(Exception e)
		{
			System.out.print(e.getMessage());
			e.printStackTrace();
			return false;
		}
		return true;
	}	
	
	/**
	* 函数名：getTreeItemData
	* 编写者：YJ
	* 功  能：返回医疗服务信息，为创建树做好基础数据
	* 输入参数：医疗服务分类标志
	* 输出参数：医疗信息服务
	* 备  注：
	*/
	
	public void getTreeItemData(String ssFlg)
	{
		psSQL = "SELECT * FROM SFFL ";
		psSQL = psSQL + "WHERE FLDM LIKE '";
		psSQL = psSQL + ssFlg;
		psSQL = psSQL + "[A-Z]%' ";//匹配A%或者B%，但不包括A和B
		psSQL = psSQL + "ORDER BY FLDM ";
		
		try
		{
			prs = stmt.executeQuery(psSQL);
		}
		catch(SQLException se)
		{
			System.out.print(se.getMessage());
			se.printStackTrace();
		}
	}
	
	/**
	* 函数名：getSfxmData()
	* 编写者：XY
	* 功  能：返回收费标准信息
	* 输入参数：无
	* 输出参数：无
	* 备  注：
	*/	
	
	public void getSfxmData()
	{	
		psSQL = "SELECT * FROM SFBZ ";
		try
		{
		    
			 
				 
			prs = stmt.executeQuery(psSQL);
				
				
			}
		catch(SQLException se)
		{
			System.out.print(se.getMessage());
			se.printStackTrace();
		}
		}
	
	/**
	* 函数名：getSfnm()
	* 编写者：XY
	* 功  能：返回最大收费标准内部代码
	* 输入参数：无
	* 输出参数：最大收费标准内部代码
	* 备  注：
	*/	
	
	public String getSfnm()
	{	int maxSfnm=0;
		String maxSfnmData;
		char s[];
		
		psSQL = " SELECT MAX(SFNM) as SFNM FROM SFBZ ";
		try
		{	
			
			prs = stmt.executeQuery(psSQL);
			prs.next();
			
			maxSfnm= prs.getInt("SFNM");
			
				
			}
			
		catch(SQLException se)
		{
			System.out.print(se.getMessage());
			se.printStackTrace();
		}
			maxSfnm=maxSfnm+1000001;
		
		    maxSfnmData = String.valueOf(maxSfnm);
		    
		    
		    s=new char[6];
		    maxSfnmData.getChars(1,7,s,0);
		    
		    maxSfnmData= String.valueOf(s);
		    
			return maxSfnmData;
	
		}
	
	/**
	* 函数名：Insert()
	* 编写者：XY
	* 功  能：添加收费标准
	* 输入参数：收费标准内部代码、收费项目名、输入代码、单价、单位、自费比例、分类代码、外部连接代码、备注
	* 输出参数：是否插入成功 
	* 备  注：
	*/	
	
	public boolean Insert(String SfnmNa, 
						  String SfxmName, 
						  String SfsrName,
						  float SfdjName, 
						  String JjdwName, 
						  String ZfblName, 
						  String SfflName, 
						  String SfwmName, 
						  String BzName )
		{ 
	
		psSQL = "INSERT INTO [SFBZ]([SFNM],[SFXM],[SFSR],[SFDJ],[JJDW],[ZFBL],[SFFL],[SFWM],[BZ])VALUES(";
		psSQL = psSQL +"'"+ SfnmNa+"'"+",";
		psSQL = psSQL +"'"+ SfxmName+"'"+",";
		psSQL = psSQL +"'"+ SfsrName+"'"+",";
		psSQL = psSQL + SfdjName+",";
		psSQL = psSQL +"'"+JjdwName+"'"+",";
		psSQL = psSQL + "'"+ZfblName+"'"+",";
		psSQL = psSQL + "'"+SfflName+"'"+",";
		psSQL = psSQL + "'"+SfwmName+"'"+",";
		psSQL = psSQL +"'"+ BzName+"'";
		psSQL = psSQL + ")";
		
		System.out.println(psSQL);	
			try{
			   stmt.executeUpdate(psSQL);
			   conn.commit();
			   return true;
			}
			catch (SQLException e){
			System.out.println(e.getMessage());
			e.printStackTrace();
		}
			return false;
	}
	
	/**
	* 函数名：Update()
	* 编写者：XY
	* 功  能：修改收费标准
	* 输入参数：收费标准内部代码、收费项目名、输入代码、单价、单位、自费比例、分类代码、外部连接代码、备注
	* 输出参数：是否修改成功 
	* 备  注：
	*/	
	
	public boolean Update(String SfnmNam,
						  String SfxmNam, 
						  String SfsrNam,
						  float SfdjNam, 
						  String JjdwNam, 
						  String ZfblNam, 
						  String SfflNam, 
						  String SfwmNam, 
						  String BzNam)
		{
			psSQL = "UPDATE [SFBZ] ";
			psSQL = psSQL +"SET [SFXM]="+"'"+SfxmNam+"'"+",";
			psSQL = psSQL +"[SFSR]="+"'"+SfsrNam+"'"+",";
			psSQL = psSQL +"[SFDJ]="+SfdjNam+",";
			psSQL = psSQL +"[JJDW]="+"'"+JjdwNam+"'"+",";
			psSQL = psSQL +"[ZFBL]="+"'"+ZfblNam+"'"+",";
			psSQL = psSQL +"[SFFL]="+"'"+SfflNam+"'"+",";
			psSQL = psSQL +"[SFWM]="+"'"+SfwmNam+"'"+",";
			psSQL = psSQL +"[BZ]="+"'"+BzNam+"'";
			
			psSQL = psSQL +"WHERE [SFNM] LIKE '";
			psSQL = psSQL + SfnmNam + "'";
			
			System.out.println(psSQL);
			
			
			
			
			try{
			   stmt.executeUpdate(psSQL);
			   conn.commit();
			   return true;
			}
			catch (SQLException e){
			System.out.println(e.getMessage());
			e.printStackTrace();
		}
			
			
			return false;
			}
			
			
				 			
	
	/*
	*关闭数据库
	*/	
	public void closeDB()
	{
		try
		{
			conn.commit();
			if (!conn.isClosed())
				conn.close();
				System.out.println("数据库关闭");
		}
		catch(SQLException se)
		{
			System.out.print(se.getMessage());
			se.printStackTrace();
		}
	}
}