userinsert.java

来自「dwr分页就是 ajax的一个框架拉 可以通过javascript在前台调用后」· Java 代码 · 共 42 行

package com.jw.dao;

import com.jw.po.User;
import java.sql.*;

import com.jw.db.*;

public class UserInsert {
	private Connection con;

	private Statement st;

	private ResultSet re;

	public boolean insert(User user) {
		con = Dbmanage.getcon();
		try {
			st = con.createStatement();
			String sql = "insert users values (" + user.getUserID() + ",'"
					+ user.getUserName() + "','" + user.getUserPwd() + "')";
			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();
			}
		}
	}
}