public static void dataAdd(Connection conn)
{
PreparedStatement ps = null;
String sql3 = "Insert into a_account (user_name,pass_word,salt) values(?,?,?)";
try {
ps = conn.prepareStatement(sql3);
ps.setString(1, "abcdefg");
ps.setString(2, "123456788");
ps.setString(3, "adfafasdf");
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataUpdate(Connection conn)
{
PreparedStatement ps = null;
String sql2 = "Update a_account set user_name = ? where user_name = ?";
try {
ps = conn.prepareStatement(sql2);
ps.setString(1, "dxdx");
ps.setString(2, "abcdefg");
int num = ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataDelete(Connection conn)
{
PreparedStatement ps = null;
String sql4 = "delete from a_account where user_name = ?";
try {
ps = conn.prepareStatement(sql4);
ps.setString(1, "abcdefg");
int num = ps.executeUpdate();
System.out.println("一共影响到" +num + " 行");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataRead(Connection conn)
{
PreparedStatement ps = null;
String sql1 = "select account_id, user_name, pass_word, salt from a_account";
try {
ps = conn.prepareStatement(sql1);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
int id = rs.getInt(1);
String username = rs.getString(2);
String psword = rs.getString(3);
String salt = rs.getString(4);
System.out.println(id + ":" + username + ":" + psword + ":" + salt);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
{
PreparedStatement ps = null;
String sql3 = "Insert into a_account (user_name,pass_word,salt) values(?,?,?)";
try {
ps = conn.prepareStatement(sql3);
ps.setString(1, "abcdefg");
ps.setString(2, "123456788");
ps.setString(3, "adfafasdf");
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataUpdate(Connection conn)
{
PreparedStatement ps = null;
String sql2 = "Update a_account set user_name = ? where user_name = ?";
try {
ps = conn.prepareStatement(sql2);
ps.setString(1, "dxdx");
ps.setString(2, "abcdefg");
int num = ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataDelete(Connection conn)
{
PreparedStatement ps = null;
String sql4 = "delete from a_account where user_name = ?";
try {
ps = conn.prepareStatement(sql4);
ps.setString(1, "abcdefg");
int num = ps.executeUpdate();
System.out.println("一共影响到" +num + " 行");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void dataRead(Connection conn)
{
PreparedStatement ps = null;
String sql1 = "select account_id, user_name, pass_word, salt from a_account";
try {
ps = conn.prepareStatement(sql1);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
int id = rs.getInt(1);
String username = rs.getString(2);
String psword = rs.getString(3);
String salt = rs.getString(4);
System.out.println(id + ":" + username + ":" + psword + ":" + salt);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}