?? insert.java
字號:
package Bean;
import java.sql.*;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Insert {
Connection conn = null;
// conn.createStatement().executeUpdate("insert into UsersTable(ID, userName, passWord) values('aaa','bbb','aaa')");
public void Insert(UserBean user)
{
conn = new DBConn().getConn();
String sql = null;
sql = "INSERT INTO users (userName, password,gender,email,telphone,money,usertype) VALUES (?,?,?,?,?,?,?)";
try {
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, user.getUsername());
ps.setString(2, user.getPassword());
ps.setString(3, user.getGender());
ps.setString(4, user.getEmail());
ps.setString(5, user.getTelphone());
ps.setDouble(6, user.getMoney());
ps.setString(7, user.getUsertype());
ps.executeUpdate();//
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("數(shù)據(jù)成功插入到數(shù)據(jù)庫中!");
}
public void Clean()
{
String sql;
try
{
Connection conn=new DBConn().getConn();
sql = "";
PreparedStatement ps=conn.prepareStatement(sql);
ps.execute();
ps.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -