usersinsert.java

dwr和spring集成简单例子,包括整个工程的代码

package com.jw.dao;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

import com.jw.bean.Userbean;
import com.jw.db.*;

public class Usersinsert {
	private Connection con;

	private Statement st;

	private ResultSet re;

	// 插入操作
	public boolean insert(Userbean bean) {
		String sql = "insert into users values('" + bean.getSname() + "','"
				+ bean.getSpass() + "')";
		Dbmanage db = Dbmanage.getDb();
		try {
			con = db.getcon();
			st = con.createStatement();
			int num = st.executeUpdate(sql);
			if (num > 0) {
				return true;
			} else {
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		} finally {
			try {
				st.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

	// 查询操作
	public List findall() {
		List l = new ArrayList();
		String sql = "select * from users";
		Dbmanage db = Dbmanage.getDb();
		con = db.getcon();
		try {
			st = con.createStatement();
			re = st.executeQuery(sql);
			while (re.next()) {
				Userbean bean = new Userbean();
				bean.setSid(re.getInt("sid"));
				bean.setSname(re.getString("sname"));
				bean.setSpass(re.getString("spass"));
				l.add(bean);
			}
			return l;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} finally {
			try {
				re.close();
				st.close();
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	// 删除
	public boolean del(int sid) {
		String sql = "delete users where sid=" + sid + "";
		Dbmanage db = Dbmanage.getDb();
		try {
			con = db.getcon();
			st = con.createStatement();
			int num = st.executeUpdate(sql);
			if (num > 0) {
				return true;
			} else {
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		} finally {
			try {
				st.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}

	// 修改
	public boolean update(Userbean bean) {
		String sql = "update users set sname='" + bean.getSname() + "',spass='"
				+ bean.getSpass() + "' where sid=" + bean.getSid() + "";
		Dbmanage db = Dbmanage.getDb();
		try {
			con = db.getcon();
			st = con.createStatement();
			int num = st.executeUpdate(sql);
			if (num > 0) {
				return true;
			} else {
				return false;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return false;
		} finally {
			try {
				st.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	//根据sid查询
	public Userbean findid(int sid) {
		String sql = "select * from users where sid="+sid+"";
		Dbmanage db = Dbmanage.getDb();
		con = db.getcon();
		try {
			st = con.createStatement();
			re = st.executeQuery(sql);
			Userbean bean = new Userbean();
			while (re.next()) {
				bean.setSid(re.getInt("sid"));
				bean.setSname(re.getString("sname"));
				bean.setSpass(re.getString("spass"));
			}
			return bean;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			return null;
		} finally {
			try {
				re.close();
				st.close();
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}