?? logindemo.java
字號:
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class LoginDemo extends HttpServlet{
private String dbURL="jdbc:odbc:example"; //數(shù)據(jù)庫標識名
private String user="devon"; //數(shù)據(jù)庫用戶
private String password="book"; //數(shù)據(jù)庫用戶密碼
private Connection con;
public void init() {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //裝載數(shù)據(jù)庫驅(qū)動
con=DriverManager.getConnection(dbURL,user,password); //獲取連接
}
catch (Exception ex){
ex.printStackTrace();
}
}
public void doGet(HttpServletRequest request,HttpServletResponse response){
try{
response.setContentType("text/html;charset=gb2312"); //設(shè)置頭部
PrintWriter out=response.getWriter(); //得到PrintWriter實例
String name,password; //變量聲明
name=request.getParameter("name"); //得到參數(shù)
password=request.getParameter("password");
out.println("<HTML><HEAD><TITLE>a</TITLE></HEAD>"); //輸出信息到客戶端
out.println("<BODY>");
if (validateUser(name,password)){ //調(diào)用驗證用戶方法
out.println("<P><H3>驗證成功</H3></P>"); //顯示驗證結(jié)果
}
else{
out.println("<P><H3>驗證失敗</H3></P>");
}
out.println("</BODY></HTML>");
}
catch (Exception ex){
ex.printStackTrace(); //輸出錯誤信息
}
}
public boolean validateUser(String username, String password) {
try{
String sqlStr="select * from users where name=\'"+username+"\' and password=\'"+password+"\'"; //SQL查詢語句
Statement st=con.createStatement(); //獲取PreparedStatement對象
ResultSet rs=st.executeQuery(sqlStr); //執(zhí)行查詢
if (rs.next()){ //查詢結(jié)果
return true;
}
st.close();
}
catch (Exception ex){
ex.printStackTrace();
return false;
}
return false;
}
public void destroy() {
try {
con.close(); //關(guān)閉連接
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -