81,092
社区成员
发帖
与我相关
我的任务
分享
package com.CRM.Teller.Util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.CRM.Bean.Nodes;
/**
* 和数据库连接
**/
public class DBConnection {
private static Connection conn = null;
/*
* 一个取得连接的静态方法
*/
public static Connection getConnection() {
try {
// 加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
// 创建连接
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:orcl", "SCOTT", "tiger");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
return conn;
}
public ArrayList<Nodes> getNodeInfo() {
String sql = "select nodeId ,parentId ,hrefAddress ,nodeName from tree_table order by id ";
PreparedStatement pre = null;
Connection conn = null;
conn = getConnection();
ResultSet rs = null;
System.out.println(conn);
ArrayList<Nodes> list = new ArrayList<Nodes>();
try {
pre = conn.prepareStatement(sql);
rs = pre.executeQuery();
while (rs.next()) {
Nodes node = new Nodes();
node.setHrefAddress(rs.getString("hrefAddress"));
node.setNodeId(rs.getString("nodeId"));
node.setParentId(rs.getString("parentId"));
node.setNodeName(rs.getString("nodeName"));
list.add(node);
}
rs.close();
pre.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
} finally {
pre = null;
conn = null;
rs = null;
}
return list;
}
}
package com.CRM.Teller.Servlet;
call = conn.prepareCall("{call Login_Service(?,?,?,?,?)}");
call.setString(1, userName);
call.setString(2, passWord);
call.registerOutParameter(3, oracle.jdbc.OracleTypes.INTEGER);
call.registerOutParameter(4, oracle.jdbc.OracleTypes.VARCHAR);
call.registerOutParameter(5, oracle.jdbc.OracleTypes.CURSOR);
call.execute();
int result = call.getInt(3);
String userId = call.getString(4);
ResultSet rs = (ResultSet) call.getObject(5);
List idList = new ArrayList();
List nameList = new ArrayList();
while(rs.next()){
String roleId = rs.getString(1);
idList.add(roleId);
String roleName = rs.getString(2);
nameList.add(roleName);
System.out.println(rs.getString(2));
}
System.out.println("userId:="+userId);
if(result == 1){
HttpSession session = request.getSession();
session.setAttribute("roleId", idList);
session.setAttribute("roleName", nameList);
session.setAttribute("userId", userId);
session.setAttribute("loginName", userName);
if(nameList.size() != 1){
response.sendRedirect("ChooseRole.jsp");
}else{
response.sendRedirect("ViewServlet?Role="+idList.get(0));
}
}