java 添加记录到数据库教程
这应该是一款基本的java入门教程哦,他是先连接数据库,如果数据库连接成功后,再尝试把用户提交的数据添加到数据表哦。
import java.sql.*;
public class register
{
string logname,realname,password,email,phone,address;
string message;
connection con;
statement sql;
resultset rs;
public static void main(string args[])
{
register my=new register();
my.logname="b";
my.realname="b";
my.password="b";
my.email="www.111cn.net";
my.phone="b";
my.address="b";
my.additem();
system.out.println(my.message);
}
public register()
{
//加载桥接器:
try
{
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
}
catch(classnotfoundexception e){}
}
//设置属性值、获取属性值的方法:
public void setlogname(string name)
{
logname=name;
}
public string getlogname()
{
return logname;
}
public void setrealname(string name)
{
realname=name;
}
public string getrealname()
{
return realname;
}
public void setpassword(string pw)
{
password=pw;
}
public string getpassword()
{
return password;
}
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 string getmessage()
{
return message;
}
//添加记录到数据库的user表:
public void additem()
{try
{
con=drivermanager.getconnection("jdbc:odbc:shop","","");
sql=con.createstatement();
string s="'"+logname+"'"+","+"'"+realname+"'"+","+"'"+password+"'"+","+"'"+
email+"'"+","+"'"+phone+"'"+","+"'"+address+"'";
string condition="insert into user values"+"("+s+")";
sql.executeupdate(condition);
message="注册成功了";
con.close();
}
catch(sqlexception e)
{
message=e.getmessage();//+"http://down.111cn.net提示你:你还没有注册,或该用户已经存在,请你更换一个名字";
}
}
}