frmypxmdb.java

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

package Myprojects.FrmYPXMDb;

import java.sql.*;

public class FrmYPXMDb{	
	
	public ResultSet rs = null;
	public int count = 0;
	//public boolean flg = false;
	String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String dbConn = "jdbc:odbc:DbServer";    
	Connection con;	
	Statement stmt;
	
	
public boolean getConnection() {
    try {
        //加载驱动程序
        Class.forName(dbDriver);
        //建立连接
        con = DriverManager.getConnection(dbConn);
        //关闭自动提交
        con.setAutoCommit(false);
        //设定事务级别
        con.setTransactionIsolation(con.TRANSACTION_SERIALIZABLE);
        //创建一个JDBC声明
        stmt = con.createStatement();
        return true;
    }
    catch (Exception e) 
    {
        System.out.println(e.getMessage());
        e.printStackTrace();
        return false;
    }
    
}
	
	//执行查询	
public int getData() {    
    	
    	try {  
    		  		
    		//sql字符串
            String strSQL = "select * from YPXX";            
    		rs = stmt.executeQuery(strSQL);
    		return 1;	
    	
 
    	}
    	catch (SQLException e) 
    	
    	{
        	System.out.println(e.getMessage());
        	e.printStackTrace();  
        	return 0;      	
    	}
    	   	 	
   }	 	
	
public int getDataSFFL() {    
    	
    try {  
    		  		
		//sql字符串
        String strSQL = "";            
        strSQL = "select * from SFFL";            
		rs = stmt.executeQuery(strSQL);
	    return 1;	
	

		}
	catch (SQLException e) 
	
		{
    	System.out.println(e.getMessage());
    	e.printStackTrace();  
    	return 0;      	
		}
    	   	 	
		}
		

public int getCmb(String temp)
	{
		
		String sql = "select distinct " +  temp  +" from YPXX";							
		try																	//try，catch块	
		{
	
			rs = stmt.executeQuery(sql);									//执行sql语句
        	return 1 ;														//返回1			
			
		}
		catch(SQLException e)
		{
	
			System.out.println(e.getMessage());								//出错信息
			e.printStackTrace();
			return 0;														//返回0
	
		}
			
	}


public int getNumber()
	{
		try
		{
			String sql = "select count(*) as NUMBER from YPXX";
			rs = stmt.executeQuery(sql);
			return 1;
		}
		catch(SQLException e)
		{
			System.out.println(e.getMessage());
	    	e.printStackTrace();  
	    	return 0; 
		}
	
	}		


public int updata(String YPNM,String YM,String GG,String CD,String CJ,String YPSR,String JJDW,
					Double YPDJ,String JX,String ZFBL,String YPWM,String BZ)
	{
	
		String sql = "update YPXX set ";											
		sql = sql + " YM = '" + YM + "'";
		
		if(GG.equals("null"))											
			sql = sql + ",GG = null ";
		else
			sql = sql + ",GG = '" + GG + "'";							
	
		
		if(CD.equals("null"))											
			sql = sql + ",CD = null ";
		else
			sql = sql + ",CD = '" + CD + "'" ;						
		
	
		if(CJ.equals("null"))											
			sql = sql + ",CJ = null ";
		else
			sql = sql + ",CJ = '" + CJ + "'";						
		
	
		if(YPSR.equals("null"))											
			sql = sql + ",YPSR = null ";
		else
			sql = sql + ",YPSR = '" + YPSR + "'";								
		
		
		if(JJDW.equals("null"))											
			sql = sql + ",JJDW = null ";
		else
			sql = sql + ",JJDW = '" + JJDW + "'" ;						
		

		sql = sql + ",YPDJ = " + YPDJ;						
		
		sql = sql + ",JX = '" + JX + "'";								
		
		sql = sql + ",ZFBL = '" + ZFBL + "'" ;						
		
	
		if(BZ.equals("null"))											
			sql = sql + ",BZ = null ";
		else
			sql = sql + ",BZ = '" + BZ + "'";						
		
	
		sql = sql + "where YPNM = '" + YPNM + "'";							
		
		System.out.println(sql);

		try
		{
	
			stmt.executeUpdate(sql);
			con.commit();
			return 1;													
	
		}
		catch(SQLException e)
		{
	
			System.out.println(e.getMessage());								
			e.printStackTrace();
		
			try
			{
		
				con.rollback();												
		
			}
			catch(SQLException ex)
			{
		
				System.out.println(e.getMessage());							
				e.printStackTrace();	
		
			}

			return 0;														
		}	
	}

public int insert(String YPNM,String YM,String GG,String CD,String CJ,String YPSR,String JJDW,
					Double YPDJ,String JX,String ZFBL,String YPWM,String BZ)
	{
	
		String sql = "insert YPXX  ";											
		sql = sql + " YM = '" + YM + "'";
		
		if(GG.equals("null"))											
			sql = sql + ",GG = null ";
		else
			sql = sql + ",GG = '" + GG + "'";							
	
		
		if(CD.equals("null"))											
			sql = sql + ",CD = null ";
		else
			sql = sql + ",CD = '" + CD + "'" ;						
		
	
		if(CJ.equals("null"))											
			sql = sql + ",CJ = null ";
		else
			sql = sql + ",CJ = '" + CJ + "'";						
		
	
		if(YPSR.equals("null"))											
			sql = sql + ",YPSR = null ";
		else
			sql = sql + ",YPSR = '" + YPSR + "'";								
		
		
		if(JJDW.equals("null"))											
			sql = sql + ",JJDW = null ";
		else
			sql = sql + ",JJDW = '" + JJDW + "'" ;						
		

		sql = sql + ",YPDJ = '" + YPDJ + "'";						
		
		sql = sql + ",JX = '" + JX + "'";								
		
		sql = sql + ",ZFBL = '" + ZFBL + "'" ;						
		
	
		if(BZ.equals("null"))											
			sql = sql + ",BZ = null ";
		else
			sql = sql + ",BZ = '" + BZ + "'";						
		
	
		sql = sql + "where YPNM = '" + YPNM + "'";							

		try
		{
	
			stmt.executeUpdate(sql);
			con.commit();											
			return 1;													
	
		}
		catch(SQLException e)
		{
	
			System.out.println(e.getMessage());								
			e.printStackTrace();
		
			try
			{
		
				con.rollback();												
		
			}
			catch(SQLException ex)
			{
		
				System.out.println(e.getMessage());							
				e.printStackTrace();	
		
			}

			return 0;														
		}	
	}


}