?? register.java
字號(hào):
/*
* 創(chuàng)建日期 2007-4-27
*
* TODO 要更改此生成的文件的模板,請(qǐng)轉(zhuǎn)至
* 窗口 - 首選項(xiàng) - Java - 代碼樣式 - 代碼模板
*/
package yy;
/**
* @author Administrator
*
* TODO 要更改此生成的類型注釋的模板,請(qǐng)轉(zhuǎn)至
* 窗口 - 首選項(xiàng) - Java - 代碼樣式 - 代碼模板
*/
import java.sql.*;
public class Register
{ String logname="",
pasword="",
sex="",
age="",
email="",
phone="",
address="",
message="";
String backNews;//用來(lái)返回注冊(cè)是否成功。
Connection con;
Statement sql;
ResultSet rs;
public Register()
{ //加載橋接器:
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
}
//設(shè)置屬性值、獲取屬性值的方法:
public void setLogname(String name)
{ logname=name;
}
public String getLogname()
{return logname;
}
public void setAge(String n)
{ age=n;
}
public String getAge()
{return age;
}
public void setSex(String s)
{ sex=s;
}
public String getSex()
{return sex;
}
public void setPasword(String pw)
{ pasword=pw;
}
public String getPasword()
{return pasword;
}
public void setEmail(String em)
{ email=em;
}
public String getEmail()
{return email;
}
public void setPhone(String ph)
{ phone=ph;
}
public String getPhone()
{return phone;
}
public void setAddress(String ad)
{ address=ad;
}
public String getAddress()
{return address;
}
public void setMessage(String m)
{ message=m;
}
public String getMessage()
{return message;
}
public String getBackNews()
{return backNews;
}
public void setBackNews(String s)
{backNews=s;}
//添加記錄到數(shù)據(jù)庫(kù)的member表:
public void addItem()
{try{
con=DriverManager.getConnection("jdbc:odbc:friend","sa","");
sql=con.createStatement();
if(phone.length()==0) //如果用戶沒(méi)有提供電話
{phone="無(wú)";
}
if(email.length()==0) //如果用戶沒(méi)有提供Email
{email="無(wú)";
}
if(address.length()==0) //如果用戶沒(méi)有提供地址
{address="無(wú)";
}
if(message.length()==0) //如果用戶沒(méi)有提供信息
{message="無(wú)";
}
String s="'"+logname+"'"+","+"'"+pasword+"'"+","+"'"+sex+"'"+","+ "'"+age+"'"+","+ "'"+phone+"'"+","+"'"+email+"'"+","+"'"+address+"'"+","+"'"+message+"'";
String condition="INSERT INTO member(logname,pasword,sex,age,phone,email,address,message) VALUES"+"("+s+")";
sql.executeUpdate(condition);
backNews="注冊(cè)成功了";
con.close();
}
catch(SQLException e)
{//如果用戶使用member表中已經(jīng)存在的名字,或使用了空字段值,就會(huì)發(fā)生SQL異常
backNews="你還沒(méi)有注冊(cè),或該用戶已經(jīng)存在,請(qǐng)你更換一個(gè)名字";
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -