104db93a5043001d1a1ea6005c522ac1

来自「fckeditor 应用 包括简单的word文档生成和级联菜单」· 代码 · 共 75 行

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;
	

创建表
 sutdents
     stuid
     stuname
     stupwd
写存储过程
   插入
   proc(usernmae in,userpwd in)
   修改密码 
   proc(uid in ,upwd in oout out number);

   返回表中所有记录
   
	public boolean insertUse(UserVo user){
	conn=new ConnDB().getConnection();
	CallableStatement cstmt=null;
	String sql="{call porc(?,?)}";
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;
	}
	
	
	
	
	
	

}