e0c16df6c8ab001d1412e7a87039532d

项目名叫网上图书馆

package com.yourcompany.struts.datebase;
import java.sql.*;

public class Database
{
	String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksystem";
	static ResultSet rs=null;
	static Connection conn=null;
	static Statement stmt=null;
	static PreparedStatement pstmt	= null ;
	public Database()
	{
		try
		{	//注册数据库驱动
			 Class.forName(driver).newInstance();
			//建立数据库连接
			conn=DriverManager.getConnection(url,"sa","sa");
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	public Connection getConn()
	{
		return conn;
	}
	 public ResultSet executeQuery(String SQL) {
		    ResultSet rs = null;
		    try {
		    	conn=this.getConn();
		      Statement st = conn.createStatement();
		    
		      rs = st.executeQuery(SQL); 
		    }
		    catch (SQLException ex) {
		      System.err.print("查询出错" + ex.getMessage());
		      System.out.print(SQL);
		    }
		    return rs;
		  }
  public boolean executeQuery11(String SQL) 
  {
	  boolean flat=false;
	  try 
	  {
		  stmt = conn.createStatement();
      	  rs = stmt.executeQuery(SQL); 
      	  if(rs.next())
      	  {
      		  flat=true;
      	  }
      	  else
      	  {
      		  flat=false;
      	  }
	  }
	  catch (SQLException ex) 
	  {
		  System.err.print("查询出错" + ex.getMessage());
		  System.out.print(SQL);
	  }
	  return flat;
  }
  public ResultSet executeQuery1(String S) 
  {
	  try 
	  {
		  stmt = conn.createStatement();
      	  rs = stmt.executeQuery(S); 
	  }
	  catch (SQLException ex) 
	  {
		  System.err.print("查询出错" + ex.getMessage());
		  System.out.print(S);
	  }
	  return rs;
  }
  public boolean executeUpdate(String SQ) 
  {
	  boolean fla = false;
	  try 
	  {
		  stmt = conn.createStatement();
		  stmt.executeUpdate(SQ);
		  fla=true;
	  }
	  catch (SQLException ex) 
	  {
		  System.err.print("更新出错" + ex.getMessage());
		  System.out.print(SQ);
	  }
	  return fla;
  }
  public static boolean checkadmin(String adminname,String adminpassword) throws SQLException
  {
	  String sql="select * from adminlogin where adminname='"+adminname+"' and adminpassword='"+adminpassword+"' and adminnumber='1' ";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  if(rs.next())
	  {
		  return true;
	  }
	  else
	  {
		  return false;
	  }
	
  }
  
  public static boolean checkuser(String adminname,String adminpassword) throws SQLException
  {
	  String sql="select * from adminlogin where adminname='"+adminname+"' and adminpassword='"+adminpassword+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  if(rs.next())
	  {
		  return true;
	  }
	  else
	  {
		  return false;
	  }
	
  }
  
  public static ResultSet getRs() throws SQLException
  {
	  String sql="select * from adminlogin";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static ResultSet sum(String username) throws SQLException
  {
	  String sql="select sum(bookborrowprice) from carduserborrow where cardusername='"+username+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static ResultSet getRs_booktype() throws SQLException
  {
	  String sql="select * from userregister";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static ResultSet userborrow(String number) throws SQLException
  {
	  String sql="select * from userborrow where userid='"+number+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static boolean admin_user_insert(String adminusername,String adminuserpassword,String admintruename,String select,String adminnumber) throws SQLException
  {
	 String sql="insert into adminlogin (adminname,adminpassword,admintruename,adminshuoming,adminnumber) values('"+adminusername+"','"+adminuserpassword+"','"+admintruename+"','"+select+"','"+adminnumber+"')";
	 Database data=new Database();
	 Connection conn=data.getConn();
	 Statement stmt=conn.createStatement();
	 int i=stmt.executeUpdate(sql);
	if(i>0)
	{
		return true;
	}
	else
	{
		return false;
	}
  }
  
  public static ResultSet getRs1() throws SQLException
  {
	  String sql="select * from adminlogin where adminnumber<'3'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static ResultSet getbookinfo() throws SQLException
  {
	  String sql="select top 8 * from adminbookinfo order by bookintime desc";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  public static ResultSet getregister(String username) throws SQLException
  {
	  String sql="select * from userregister where username='"+username+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  
  public static boolean getbookid(String bookid) throws SQLException
  {
	  String sql="select * from adminbookinfo where bookid='"+bookid+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  if(rs.next())
	  {
		  return true;
	  }
	  else
	  {
		  return false;
	  }
  }
  
  
  public static ResultSet getRs_leihailong(String sql) throws SQLException
  {
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  ResultSet rs=stmt.executeQuery(sql);
	  return rs;
  }
  
  public static boolean admin_login_update(String adminname,String adminpassword,String admintruename,String adminxingzhi,String id) throws SQLException
  {
	  String sql="update adminlogin set adminname='"+adminname+"',adminpassword='"+adminpassword+"',admintruename='"+admintruename+"',adminshuoming='"+adminxingzhi+"'where id='"+id+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();
	  Statement stmt=conn.createStatement();
	  int i=stmt.executeUpdate(sql);
	  if(i>0)
	  {
		  return true;
	  }
	  else
	  {
		  return false;
	  }
  }
  public static boolean admin_booktype_update(String id,String adminbooktype) throws SQLException
  {
	  String sql="update adminbooktype set adminbooktype='"+adminbooktype+"' where id='"+id+"'";
	  Database data=new Database();
	  Connection conn=data.getConn();