mysql.java

it s a java feil,not very good !

package server;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import cmsc.c;

public class mysql {
	 static String dbdriver="com.mysql.jdbc.Driver";
	 static String dburl="jdbc:mysql://localhost:3306/telephone1";
	 static String dbuser="root";
	 static String dbpassword="000";
	 static Connection conn=null;
	 static Statement stmt;
	 public mysql(){
	 try
	  { 
	    Class.forName(dbdriver);
	    conn=DriverManager.getConnection(dburl,dbuser,dbpassword);
	    stmt=conn.createStatement();
	  }catch(Exception e){
		  System.out.println(e);
	  }
	 }
	public void denglu(String id,String password) {
		try
		  {
			String s1="'"+id+"'", s2="'"+password+"'";

		    String sql="select * from staff where sid="+s1+" and spassword="+s2;
		    ResultSet result=stmt.executeQuery(sql);
		    while(result.next()){
		    	c.o=true;
		    }
		  }
		  catch(Exception e)
		  {System.out.println(e);c.i=0;c.o=false;}
	}
	public void tianjia(String id,String password){
		try
		  {
		String s1="'"+id+"'",
		s2="'"+password+"'";
	    String sql="insert into person values ('1'," +s1+","+s2+")";
	    stmt.executeUpdate(sql);
	    System.out.println("插入成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void xiugai(String cnumber,String cname,String csex,String caddr){
		try
		  {
			System.out.println("开始操作");
			String s1="'"+cnumber+"'", s2="'"+cname+"'",
			s3="'"+csex+"'", s4="'"+caddr+"'";

		    String sql="update customer set cname="+s2+",csex="+s3+",caddr="+s4+" where cnumber="+s1;
		    stmt.executeUpdate(sql);
		    System.out.println("操作成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
}
	public void yxiugai(String sid,String spassword,String sname,String ssex,String sage){
		try
		  {
			System.out.println("开始操作");
			String s="'"+spassword+"'",s1="'"+sid+"'", s2="'"+sname+"'",
			s3="'"+ssex+"'", s4="'"+sage+"'";

		    String sql="update staff set sname="+s2+",ssex="+s3+",sage="+s4+",spassword="+s+" where sid="+s1;
		    stmt.executeUpdate(sql);
		    System.out.println("操作成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
}
	public void tianjia(String cnumber,String cname,String csex,String caddr){
		try
		  {
			System.out.println("开始操作");
			String s1="'"+cnumber+"'", s2="'"+cname+"'",
			s3="'"+csex+"'", s4="'"+caddr+"'",
			s5=s1+","+s2+","+s3+","+s4;

		    String sql="insert into customer(cnumber,cname,csex,caddr) values("+s5+")";
		    String sq="insert into bill(cnumber,cmoney) values("+s1+",'0')";
		    stmt.executeUpdate(sql);
		    stmt.executeUpdate(sq);
		    System.out.println("操作成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void ytianjia(String sid,String spassword,String sname,String ssex,String sage){
		try
		  {
			System.out.println("开始操作");
			String s="'"+spassword+"'",s1="'"+sid+"'", s2="'"+sname+"'",
			s3="'"+ssex+"'", s4="'"+sage+"'",
			s5=s1+","+s2+","+s3+","+s4+","+s;

		    String sql="insert into staff values("+s5+")";
		    stmt.executeUpdate(sql);
		    System.out.println("操作成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void chaxun(String cnumber){
		try
		  {
			String s1="'"+cnumber+"'";
			System.out.println(s1);

		    String sql="select * from customer where cnumber="+s1;
		    String sq="select * from bill where cnumber="+s1;
		    ResultSet result=stmt.executeQuery(sql);
		    while(result.next()){
		    	c.name=result.getString("cname");
		    	c.sex=result.getString("csex");
		    	c.addr=result.getString("caddr");
		    	c.zhucetime=result.getString("ctime");
		    	c.o=true;
		    }
		    ResultSet result1=stmt.executeQuery(sq);
		    while(result1.next()){
		    	c.yue=result1.getString("cmoney");
		    	c.i=1;
		    }
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void ychaxun(String sid){
		try
		  {
			String s1="'"+sid+"'";
			System.out.println(s1);

		    String sql="select * from staff where sid="+s1;
		    ResultSet result=stmt.executeQuery(sql);
		    while(result.next()){
		    	c.name=result.getString("sname");
		    	c.sex=result.getString("ssex");
		    	c.age=result.getString("sage");
		    	c.password=result.getString("spassword");
		    	c.o=true;
		    }
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void shanchu(String cnumber){
		try
		  {
			String s1="'"+cnumber+"'";
			System.out.println(s1);

		    String sql="delete from customer where cnumber="+s1;
		    stmt.executeUpdate(sql);
		    String sq="delete from bill where cnumber="+s1;
		    stmt.executeUpdate(sq);
		    stmt.executeUpdate("commit");
		    c.number="";
		    c.name="";
		    c.sex="";
		    c.addr="";
		  }catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void yshanchu(String sid){
		try
		  {
			String s1="'"+sid+"'";
			System.out.println(s1);

		    String sql="delete from staff where sid="+s1;
		    stmt.executeUpdate(sql);
		    stmt.executeUpdate("commit");
		    c.id="";
		    c.name="";
		    c.sex="";
		    c.age="";
		    c.password="";
		  }catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void jiaofei(String cnumber,String pay){
		try
		  {String bl = null;
			String s1="'"+cnumber+"'";
			int s2=Integer.parseInt(pay);
			System.out.println(s1);

		    String sql="select * from bill where cnumber="+s1;
		    ResultSet result=stmt.executeQuery(sql);
		    while(result.next()){
		    	bl=result.getString("cmoney");
		    	System.out.println(bl);
		    }
		    int s4=s2+Integer.parseInt(bl);
		    String s3="'"+Integer.toString(s4)+"'";
			  stmt.executeUpdate("update bill set cmoney="+s3+"where cnumber="+s1);
			  System.out.println(s4);
			  c.yue=Integer.toString(s4);
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	public void diary(String sid,String cnumber,String pay,String caozuo){
		try
		  {
			System.out.println("开始操作");
			String s1="'"+sid+"'", s2="'"+cnumber+"'",s3="'"+pay+"'",s4="'"+caozuo+"'";
			String s5=s1+","+s2+","+s3+","+s4;
		    String sql="insert into diary(sid,cnumber,pay,caozuo) values("+s5+")";
		    stmt.executeUpdate(sql);
		    System.out.println("操作成功");
		  }
		  catch(Exception e)
		  {System.out.println(e);c.o=false;}
	}
	 public void close(){
		 try {
			 stmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	 }
}