jdbc模版

</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 block
		e.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 block
		e.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 block
		e.printStackTrace();
	}finally{				
		JdbcUtils.release(rs, pst, con);
		}
 }
	  
 }