package jbdc;

import java.sql.*;

import tools.DBUtil;

public class _3_insert {
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Connection conn = DBUtil.getConn();
		PreparedStatement psmt = null;
		
		///     插入      //
		
		try {
			String sql = "insert into user values(?,?,?,?)";
			psmt = conn.prepareStatement(sql);
			psmt.setString(1, "20002");
			psmt.setString(2, "111");
			psmt.setString(3, "陈健");
			psmt.setString(4, "管理员");
			int i = psmt.executeUpdate();//如果插入成功那么返回的值大于0,不成功就返回0
			if(i!=0)
				System.out.println("插入成功");
			else
				System.out.println("插入失败");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			DBUtil.close(psmt, conn);
		}
			
	}
	
}