java jdbc 增删读改

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();
}

}