Java JDBC sqlserver连接（增删改）方法二

来源：互联网发布：哈尔滨管家婆软件编辑：程序博客网时间：2024/05/23 21:10

jdbc驱动包要网上下载

sqljdbc4.jar

sqljdbc_4.0.rar

所有的import包要放到项目目录下的\WebContent\WEB-INF\lib里

//Initialization.java

package szy.shopping.dao;import java.sql.Connection;import java.sql.DriverManager;public class Initialization {private Connection con;public Initialization(){con=null;}//初始化public  Connection init(){try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=shoppingDB","sa","xxx");} catch (Exception e) {System.out.println("CustomerDAO.init ERROR ## "+e.getMessage());}return con;}}

//AdminDAO.java

package szy.shopping.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import szy.shopping.entity.Admin;public class AdminDAO {Connection con;PreparedStatement pstm;ResultSet rs;public AdminDAO(){Initialization initialization=new Initialization();con=initialization.init();}//查询管理员密码是否正确public boolean checkAdmin(Admin admin){boolean result=false;try {pstm=con.prepareStatement("select * from Admin where userName=? and password=?");pstm.setObject(1, admin.getUserName());pstm.setObject(2, admin.getPassword());rs=pstm.executeQuery();if(rs.next())  //存在结果result=true;destroy();} catch (Exception e) {System.err.println("AdminDAO.checkAdmin ERROR ## "+e.getMessage());}return result;}//修改密码public boolean changePassword(String userName,String newPassword){boolean result=false;try {pstm=con.prepareStatement("update admin set password=? where userName=?");pstm.setObject(1, newPassword);pstm.setObject(2, userName);pstm.execute();result=true;destroy();} catch (Exception e) {System.err.println("AdminDAO.changePassword ERROR ## "+e.getMessage());}return result;} //添加新客户public boolean addNewAdmin(Admin admin){boolean result=false;try {pstm=con.prepareStatement("insert into Admin values(?,?)");pstm.setObject(1, admin.getUserName());pstm.setObject(2, admin.getPassword());pstm.execute();result=true;destroy();} catch (Exception e) {System.err.println("AdminDAO.addNewAdmin ERROR ## "+e.getMessage());}return result;}//释放资源private void destroy(){try {if(rs!=null){rs.close();}if(pstm!=null){pstm.close();}if(con!=null){con.close();}} catch (Exception e) {System.out.println("CustomerDAO.destroy ERROR ## "+e.getMessage());}}////public static void main(String[] args) {////AdminDAO admin=new AdminDAO();////System.out.println(admin.checkAdmin("admin", "admin"));////System.out.println(admin.changePassword("admin", "admin"));////System.out.println(admin.addNewAdmin("coolszy", "kuka"));//}}

阅读全文

0 0