0024808f4f43001d1a1ea6005c522ac1

fckeditor 应用 包括简单的word文档生成和级联菜单

package net.dbet;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Model {
	Connection conn=null;
	Statement stmt=null;
	ResultSet rs=null;
	PreparedStatement pstmt=null;
	
	/*\
	 * create sequence seq_user ;
	 * create or replace procedure proc(username in user.unemae%type,userpwd in user.upwd%type)
	 * as
	 * begin
	 * insert into user values(seq_user.nextval,username,userpwd);
	 * commit;
	 * end;
	 * 
	 * 
	 * */
	public boolean insertUse(UserVo user){
	conn=new ConnDB().getConnection();
	CallableStatement cstmt=null;
	String sql="{call proc(?,?)}";
try {
	cstmt=conn.prepareCall(sql);
	cstmt.setInt(1, user.getUserid());
	cstmt.setString(2,user.getUsername());
	cstmt.execute();
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
	
		
		
		
		
		
		return false;
		
		
	}
	public boolean insertUser(UserVo user){
		conn=new ConnDB().getConnection();
		String sql="insert into User_tables values (?,?)";
		try {
			pstmt=conn.prepareStatement(sql);
			pstmt.setInt(1, user.getUserid());
			pstmt.setString(2, user.getUsername());
			pstmt.execute();
			
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		
		
		return false;
	}
	
	
	
	
	
	

}