Information Technology
JDBC DB Connect (MSSQL)
지에또일
2010. 3. 22. 14:50
<%@ page session="true" contentType="text/html; charset=UTF-8" pageEncoding="euc-kr"%>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
rs=stmt.executeQuery(SQL);
while(rs.next()){
BSC_ID = rs.getString("LOGINNAME");
BSC_PWD = rs.getString("PASSWORD");
intCount++;
} rs.close();
out.println("BSC_ID: " + BSC_ID);
out.println("BSC_PWD : " + BSC_PWD);
%>
<HTML>
<BODY></BODY>
<%@ page import="java.sql.*"%>
<%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DBNAME", "SA", "PASSWORD");
stmt=conn.createStatement();
String SQL = "";
SQL += " SELECT LOGINNAME, PASSWORD FROM HPS_USER_ACCOUNT ";
SQL += " WHERE LOGINNAME IN(SELECT EMPLOYEENUMBER FROM HPS_EMPLOYEE) AND LOGINNAME ='"+BSC_ID+"'";
ResultSet rs=null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DBNAME", "SA", "PASSWORD");
stmt=conn.createStatement();
String SQL = "";
SQL += " SELECT LOGINNAME, PASSWORD FROM HPS_USER_ACCOUNT ";
SQL += " WHERE LOGINNAME IN(SELECT EMPLOYEENUMBER FROM HPS_EMPLOYEE) AND LOGINNAME ='"+BSC_ID+"'";
rs=stmt.executeQuery(SQL);
while(rs.next()){
BSC_ID = rs.getString("LOGINNAME");
BSC_PWD = rs.getString("PASSWORD");
intCount++;
} rs.close();
out.println("BSC_ID: " + BSC_ID);
out.println("BSC_PWD : " + BSC_PWD);
%>
<HTML>
<BODY></BODY>
</HTML>
<%
<%
} catch(Exception e){
} finally{
if(stmt!=null) try{ stmt.close(); } catch(Exception e){}
if(conn!=null) try{ conn.close(); } catch(Exception e){}
}
%>
} finally{
if(stmt!=null) try{ stmt.close(); } catch(Exception e){}
if(conn!=null) try{ conn.close(); } catch(Exception e){}
}
%>
mssqlserver.jar