java通讯录+sql2008

import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Vector; public class Dao { protected static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; protected static String dbUrl = "jdbc:sqlserver://localhost:1433;" + "Database=TXL"; protected static String dbUser = "sa"; protected static String dbPwd = "123456"; protected static String second = null; private static Connection conn = null; private Dao() { try { if (conn == null) { Class.forName(dbClassName); conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd); } else return; } catch (Exception ee) { ee.printStackTrace(); } } private static ResultSet executeQuery(String sql) { try { if (conn == null) new Dao(); return conn.createStatement().executeQuery(sql); } catch (SQLException e) { e.printStackTrace(); return null; } finally { } } private static int executeUpdate(String sql) { try { if (conn == null) new Dao(); return conn.createStatement().executeUpdate(sql); } catch (SQLException e) { System.out.println(e.getMessage()); return -1; } finally { } } public static void close() { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } finally { conn = null; } } // 向下拉列表中添加分组名称 public static Vector addgroupname() { Vector v = new Vector(); String sql = "select G_NAME from tb_grouplist"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { v.add(rs.getString(1)); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return v; } // 查询 public static List selectid(String id) { List list = new ArrayList(); String sql = "select * from tb_main where ID='" + id + "'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { list.add(rs.getString(1)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } //// // 查询 // public static List select2(String name, String id) { // List list = new ArrayList(); // String sql = "select * from tb_main where 姓名='" + name + "'and ID=id"; // ResultSet rs = Dao.executeQuery(sql); // try { // while (rs.next()) { // list.add(rs.getString(3)); // list.add(rs.getString(4)); // list.add(rs.getString(5)); // list.add(rs.getString(6)); // list.add(rs.getString(9)); // } // } catch (Exception e) { // e.printStackTrace(); // } // Dao.close(); // return list; // } // // 查询 public static List select(String name, String id) { List list = new ArrayList(); String sql = "select * from tb_main where 姓名='" + name + "'and ID='" + id + "'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } //查询同一个分组里的是否存在重名 public static Vector selectname(String name, String id) { Vector v=new Vector(); String sql = "select 姓名 from tb_main where 姓名='" + name + "' and ID='" + id + "'"; ResultSet rs = Dao.executeQuery(sql); try { while(rs.next()) { v.add(rs.getString(1)); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return v; } // 查询 public static List modi_select(String name, String id) { List list = new ArrayList(); String sql = "select * from tb_main where 姓名='" + name + "'and ID='" + id + "'"; ResultSet rs = Dao.executeQuery(sql); try { while (rs.next()) { list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); list.add(rs.getString(9)); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return list; } // 查询 // public static int select3(String name,String id) { // int i=0; // try { // String sql = "select * from tb_main where 姓名='"+name+"'and ID='"+id+"'"; // i=Dao.executeUpdate(sql); // } catch (Exception e) { // e.printStackTrace(); // } // Dao.close(); // return i; // } // 添加 public static int Insert(String name, String sex, String address, String phone, String qq_number, String birthday, String e_mail, String id, String remark) { int i = 0; try { String sql = "INSERT INTO tb_main (姓名,性别,地址,联系电话,QQ号码,生日,E_mail,ID,备注) values('" + name + "','" + sex + "','" + address + "','" + phone + "','" + qq_number + "','" + birthday + "','" + e_mail + "','" + id + "','" + remark + "')"; i = Dao.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } Dao.close(); return i; } // 删除 public static int Delete(String name, String id) { int i = 0; try { String sql = "delete from tb_main where 姓名='" + name + "' and ID='" + id + "'"; i = Dao.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } Dao.close(); return i; } // 修改 public static int Update(String name, String id, String address, String phone, String qq_number, String birthday, String e_mail, String remark) {// 归还图书操作 int i = 0; try { String sql = "update tb_main SET 地址='" + address + "',联系电话='" + phone + "',QQ号码='" + qq_number + "',生日='" + birthday + "',E_mail='" + e_mail + "',备注='" + remark + "' where 姓名='" + name + "' and ID=" + id + ""; i = Dao.executeUpdate(sql); } catch (Exception e) { e.printStackTrace(); } Dao.close(); return i; } // 获取分组ID public static String getgroupid(String groupname) { String g = null; try { String sql = "select G_ID from tb_grouplist where G_NAME='" + groupname + "'"; ResultSet rs = Dao.executeQuery(sql); while (rs.next()) { g = rs.getString(1); } } catch (Exception e) { e.printStackTrace(); } Dao.close(); return g; } // 树结构中添加下拉列表中添加获取到的分组名字 public static Vector getgroupname() { Vector v = new Vector(); try { String sql = "select G_NAME from tb_grouplist"; ResultSet rs = Dao.executeQuery(sql); while (rs.next()) { v.add(rs.getString(1)); } } catch (SQLException e1) { e1.printStackTrace(); } Dao.close(); return v; } }