dbconn.java

java医院应用包含门诊挂号收费住院等应用比较好用

package hospital;

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

public class Dbconn {
	private Connection conn;
	private Statement stmt;
	private ResultSet rs;
	public Dbconn() 
	{
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?user=root&password=sist&useUnicode=true&characterEncoding=gbk");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		catch (SQLException e) {
			e.printStackTrace();
		}
	}
	public int login(String username,String password)
	{
		int a=0;
		int b=0;
		String sql="select password from hospital.user where username='"+username+"'";
		//md5 md=new md5();
		//password=md.getMD5ofStr(password);
		try {
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
			rs.last();
			b=rs.getRow();
			if (b>0)
			{
		        if(rs.getString("password").equals(password))
		        {
		        	   a=1;
		        }       
		        else
			           a=0;
			}
			else
			{
				a=0;
			}
			rs.close();
			stmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return a;
	}
public int getRoot(String username)
{
	 int a=0;
	 String sql="select root from hospital.user where username='"+username+"'";
	 try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		rs.last();
		a=rs.getInt("root");
		rs.close();
		stmt.close();
	 } catch (SQLException e) {
		e.printStackTrace();
	}
	 return a;
}
public String getName(String username)
{
	 String a="";
	 String sql="select name from hospital.user where username='"+username+"'";
	 try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		rs.last();
		a=rs.getString("name");
		rs.close();
		stmt.close();
	 } catch (SQLException e) {
		e.printStackTrace();
	}
	 return a;
}
public String getType(String username)
{
	 String a="";
	 String sql="select type from hospital.user where username='"+username+"'";
	 try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		rs.last();
		a=rs.getString("type");
		rs.close();
		stmt.close();
	 } catch (SQLException e) {
		e.printStackTrace();
	}
	 return a;
}
public int patient (String patientid,String name,String sex,int age,String moneytype,String tel,String address)
{	
	int a=0;	
	try {
		String sql="insert into hospital.patient(patientid,name,sex,age,moneytype,tel,address) values ('"+patientid+"','"+name+"','"+sex+"','"+age+"','"+moneytype+"','"+tel+"','"+address+"')";
		stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		String cksql="select * from hospital.patient where patientid='"+patientid+"'";
		rs=stmt.executeQuery(cksql);
		rs.last();
		a=rs.getRow();
		rs.close();
		stmt.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return a;
}
public int register (String regid,String patientid,String roomtype,String regtype)
{	
	int a=0;	
	try {
		Date date=new Date();
		String regtime=date.toLocaleString();
		String sql="insert into hospital.register(regid,patientid,roomtype,regtype,regtime) values ('"+regid+"','"+patientid+"','"+roomtype+"','"+regtype+"','"+regtime+"')";
		stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		String cksql="select * from hospital.register where regid='"+regid+"'";
		rs=stmt.executeQuery(cksql);
		rs.last();
		a=rs.getRow();
		rs.close();
		stmt.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return a;
}
public String getSrc(String type)
{
	 String a="";
	 if (type.equals("医生"))
	 {
		 a="/hospital/ins/loginok_doc.jsp";
	 }
	 else
	 {
		 if (type.equals("挂号"))
		 {
			 a="/hospital/ins/loginok_reg.jsp";
		 }
		 else
		 {
			 if (type.equals("收费"))
			 {
				 a="/hospital/ins/loginok_charge.jsp";
			 }
			 else
			 {
				 a="/hospital/ins/loginok_drug.jsp";
			 }
		 }
	 }
	 return a;
}
public int drugadd(String drugid,String name,String standard,int num,double uprice,String remark)
{	
	int a=0;	
	try {
		String sql="insert into hospital.drug(drugid,name,standard,num,uprice,remark) values ('"+drugid+"','"+name+"','"+standard+"','"+num+"','"+uprice+"','"+remark+"')";
		stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		String cksql="select * from hospital.drug where drugid='"+drugid+"'";
		rs=stmt.executeQuery(cksql);
		rs.last();
		a=rs.getRow();
		rs.close();
		stmt.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return a;
}
public ResultSet drugquery(String keyword,String type)
{
	
	try {
		String sql="select * from hospital.drug where "+type+" like '%"+keyword+"%'";
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return rs;
}
public void execute(String sql)
{
	
	try {
		stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		stmt.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}
public ResultSet executers(String sql)
{
	try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		rs.last();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return rs;
}
public void charge_list(String drugid,int num,String regid)
{
	
	try {
		String sql="select * from hospital.drug where drugid='"+drugid+"'";
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		rs.last();
		String name=rs.getString("name");
		double uprice=rs.getDouble("uprice");
		double price=num*uprice;
		rs.close();
		sql="insert into hospital.charge_list(regid,drugid,uprice,price,num,name) values ('"+regid+"','"+drugid+"',"+uprice+","+price+","+num+",'"+name+"')";
		stmt=conn.createStatement();
		stmt.executeUpdate(sql);
		stmt.close();
	} catch (SQLException e) {
		e.printStackTrace();
	}
}
public ResultSet exec(String sql)
{
	try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return rs;
}
public void charge(ResultSet rss)
{
	int num;
	String drugid;
	String sql;
	try {
		rss.beforeFirst();
		while(rss.next())
		{
			drugid=rss.getString("drugid");
			num=rss.getInt("num");
			sql="update hospital.drug set num=num-"+num+" where drugid='"+drugid+"'";
			stmt=conn.createStatement();
			stmt.executeUpdate(sql);
			stmt.close();
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}
}
}