adduser.java

准备： 1、启动MS-SQL服务器； 2、运行“DBCreate_MusicSky.bat”,安装本项目所需的数据库 （如果安装不成功

import java.io.*;
import java.sql.*; 
import javax.servlet.*;
import javax.servlet.http.*;

 public class adduser
 {
    private String USER_ID=" ";
    private String USER_PASSWORD=" ";
    private String passwordconfirm=" ";    
    private String USER_NAME=" ";
    private String ADDRESS=" ";
    private String PHONE=" ";
    private String EMAIL=" ";
    public Connection conn;
    public Statement stmt;
    public ResultSet rs=null;
    
     public void setUSER_ID(String USER_ID)
     {
     	this.USER_ID=USER_ID;
     }  
   
    public String getUSER_ID()
     {
     	return USER_ID;
     } 
     
     public void setUSER_PASSWORD(String USER_PASSWORD)
     {
     	this.USER_PASSWORD=USER_PASSWORD;
     }  
   
    public String getUSER_PASSWORD()
     {
     	return USER_PASSWORD;
     } 
     
     public void setpasswordconfirm(String passwordconfirm)
     {
     	this.passwordconfirm=passwordconfirm;
     }  
   
    public String getpasswordconfirm()
     {
     	return passwordconfirm;
     } 
     
     public void setUSER_NAME(String USER_NAME)
     {
     	this.USER_NAME=USER_NAME;
     }  
   
    public String getUSER_NAME()
     {
     	return USER_NAME;
     } 
     public void   setADDRESS(String ADDRESS)
     {
     	 this.ADDRESS=ADDRESS;
     }
     public String getADDRESS()
     {
     	return ADDRESS;
     }
     public void   setPHONE(String PHONE)
     {
     	this.PHONE=PHONE;
     }
     public String getPHONE()
     {
     	return PHONE;
     }
     public void setEMAIL(String EMAIL)
     {
     	this.EMAIL=EMAIL;
     }  
   
    public String getEMAIL()
     {
     	return EMAIL;
     } 
   
    public boolean add() throws Exception 
    {
    
        try
               {
	               	USER_ID=getUSER_ID();
					USER_PASSWORD=getUSER_PASSWORD();
					passwordconfirm=getpasswordconfirm();
					ADDRESS=getADDRESS();
					PHONE=getPHONE();
					EMAIL=getEMAIL();
	               
                   String sqlau="INSERT INTO userpassword VALUES('"+USER_ID+"','"+USER_PASSWORD+"','N','"+USER_NAME+"','"+ADDRESS+"','"+PHONE+"','"+EMAIL+"')";

                   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                   String url ="jdbc:odbc:MusicSky";
                   conn=DriverManager.getConnection(url,"sa","");
                   stmt = conn.createStatement();
                   stmt.executeUpdate(sqlau);                                    
                   
                   return true;                   
               }
               
          catch (Exception ee)
          {
                System.out.print(ee.getMessage());
                return false;
          }
     } 
 }