jdbc模版

来源：互联网发布：apache cgi python 编辑：程序博客网时间：2024/05/22 12:25
</pre><pre code_snippet_id="1702563" snippet_file_name="blog_20160531_2_9692751" name="code" class="java">//数据库操作package com.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import com.Student;import utils.JdbcUtils;public class UserDao {////////////////////////////////////////////////// public boolean IsExist(String name){ Connection con = null; PreparedStatement pst=null; ResultSet rs=null;try {con = JdbcUtils.getConnection(); String sql="select * from stu where username=?"; pst = con.prepareStatement(sql); pst.setString(1, name); rs=pst.executeQuery(); if(rs.next()){ return true; }} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{JdbcUtils.release(rs, pst, con);}return false; } /////////////////////////////////////////////////////////////////////////// public boolean isExist(String username,String password){ Connection con = null; Statement st = null; ResultSet rs=null;try {con = JdbcUtils.getConnection(); st = con.createStatement(); String sql="select * from stu where username='"+username+"' and password='"+password+"'";  rs = st.executeQuery(sql); if(rs.next()){return true; }} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{JdbcUtils.release(rs, st, con);}return false; } public void  saveUser(Student stu){ Connection con = null; PreparedStatement pst=null; ResultSet rs=null;try {con = JdbcUtils.getConnection(); String sql="insert into stu(username,password,sex,phone,address)values(?,?,?,?,?)"; pst = con.prepareStatement(sql); pst.setString(1,stu.getUsername()); pst.setString(2, stu.getPassword()); pst.setString(3, stu.getSex()); pst.setString(4, stu.getPhone()); pst.setString(5, stu.getAddress()); pst.executeUpdate();} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{JdbcUtils.release(rs, pst, con);} }   }
0 0