关闭

jdbc模版

95人阅读 评论(0) 收藏 举报
分类:
</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);
		}
 }
	  
 }
 
 
 
 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:3669次
    • 积分:275
    • 等级:
    • 排名:千里之外
    • 原创:25篇
    • 转载:0篇
    • 译文:0篇
    • 评论:0条
    文章分类