经典jquery局部刷新增删改查

package com.dao; import java.util.*; import java.sql.*; import com.entity.*; public class LoginDao { String drv="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String url="jdbc:sqlserver://localhost:1079;DatabaseName=mydb"; String username="sa"; String password=""; public void Add(Login login){ try { Class.forName(drv); Connection conn=DriverManager.getConnection(url,username,password); Statement stmt=conn.createStatement(); String sql="insert into login(username,password) values('"+login.getUsername()+"','"+login.getPassword()+"')"; stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public ArrayList<Login> getALL() { ArrayList<Login> list=new ArrayList<Login>(); try { Class.forName(drv); Connection conn=DriverManager.getConnection(url,username,password); Statement stmt=conn.createStatement(); String sql="select * from login"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()){ Login login=new Login(); login.setId(rs.getInt(1)); login.setUsername(rs.getString(2)); login.setPassword(rs.getString(3)); list.add(login); } rs.close(); stmt.close(); conn.close(); }catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public void Delete(int id){ try { Class.forName(drv); Connection conn=DriverManager.getConnection(url,username,password); Statement stmt=conn.createStatement(); String sql="delete from login where id="+id; stmt.executeUpdate(sql); stmt.close(); conn.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }