loadsql.java

J2EE+jsp音乐网站,提供登录

package com.music;
import java.sql.*;
public class LoadSQL {
	private Connection conn ;
	private String user="" ;
	private String pass=""; 
	private Statement StMent;
    private PreparedStatement preparedStmt;
    public LoadSQL()      //构造函数
    {
    	user="sa";
    	pass="yeguoxing";
    }
    public boolean InsertData(String SQL)
    {
      try
      {
    	  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          conn = DriverManager.getConnection("jdbc:odbc:DataSoure",user,pass);
          preparedStmt=conn.prepareStatement(SQL);
          preparedStmt.executeUpdate();
          conn.close();
    	  return true; 
      }	
      catch(Exception e)
      {
    	  System.out.println("插入数据出错\n" + e.getMessage()); 
          return false;
      }
    }
    public boolean UpdateData(String SQL)
    {
    	try
    	{
    		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:DataSoure",user,pass);
            StMent=conn.createStatement();
            StMent.executeUpdate(SQL);
            conn.close();
      	    return true; 
    	}
    	catch(Exception e)
    	{
    		System.out.println("更新数据库出错\n" + e.getMessage()); 
            return false;
    	}
    }
	public boolean DeleteData(String SQL)
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:DataSoure",user,pass);
            StMent=conn.createStatement();
            StMent.executeUpdate(SQL);
            conn.close();
		    return true;	
		}
		catch(Exception e)
		{
			System.out.println("删除数据库出错\n" + e.getMessage()); 
            return false;
		}
	}
	public int CheckUser(String SQL)
	{
	    try
	    {
	    	 int n=0;
	    	 ResultSet rs;
		     Statement StMent;
		     Connection conn;
		     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		     conn = DriverManager.getConnection("jdbc:odbc:DataSoure","sa","yeguoxing");
		     StMent=conn.createStatement();
		     rs=StMent.executeQuery(SQL);
		     StMent=conn.createStatement();
		     while(rs.next())
		     {
		        n=n+1;
		     }
		     rs.close();
		     conn.close();
		     return n;
	    }
	    catch(Exception e)
	    {
	    	return 0;
	    }
	    
	}
	public String ReturnAvalue(String SQL,int n)  //查找返回具体的某一个值
	{
		try
		{
		
	    	 ResultSet rs;
		     Statement StMent;
		     Connection conn;
		     String str="";   //用来保存返回值
		     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		     conn = DriverManager.getConnection("jdbc:odbc:DataSoure","sa","yeguoxing");
		     StMent=conn.createStatement();
		     rs=StMent.executeQuery(SQL);
		     StMent=conn.createStatement();
		     while(rs.next())
		     {
		          str=rs.getString(n);
		          break;
		     }
		     rs.close();
		     conn.close();
		     return str;
		}
		catch(Exception e)
		{
			System.out.print(e.toString());
			return "";
		}
	}
}