<%@ page language="java" import="java.util.*, java.sql.*,java.io.*" pageEncoding="UTF-8"%>
<%request.setCharacterEncoding("UTF-8");%>
<%response.setCharacterEncoding("UTF-8");%>
登录中
<%
String loginName = (String)request.getParameter("login_name");
String sql = "SELECT PASSWORD FROM hods.SYS_USER WHERE LOGIN_NAME = '" + loginName + "'";
String pwd = null;
Connection conn = null;
Statement st = null;
ResultSet rs =null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@(description=(address_list= (address=(host=66.0.37.43) (protocol=tcp)(port=1521)) (load_balance=yes)(failover=yes))(connect_data=(service_name=orcl)))";
String user="hods_cx";
String password="hods_cx";
conn = DriverManager.getConnection(url, user, password);
st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = st.executeQuery(sql);
while (rs.next()) {
pwd =rs.getString(1);
break;
}
}
catch(Exception e){
StringWriter sw = new StringWriter(1024 * 4);
PrintWriter px = new PrintWriter(sw);
e.printStackTrace(px);
out.print(sw.toString());
}
finally{
if(conn!= null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(st!= null){
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(rs!= null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
%>
