摘要:本系列会制作一个简单的需要JSP,servlet,oracle一起完成的登录,注册页面
5,需要一个dao层,用来链接数据库同时用于验证登录是否正确和插入新用户数据到数据库
1 package dao;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6 import java.sql.ResultSet;
7 import java.sql.SQLException;
8
9 public class userdata {
10 public String driver="oracle.jdbc.driver.OracleDriver";
11 public String url="jdbc:oracle:thin:@localhost:1521:orcl";
12 public String user="scott";
13 public String password="ztoracle";
14 private PreparedStatement ps;
15 private Connection co;
16 public static userdata dao;
17
18 private userdata(){
19 try {
20 Class.forName(driver);
21 } catch (ClassNotFoundException e) {
22 throw(new RuntimeException(e));
23 }
24
25 }
26
27 public static userdata getdao(){
28 if(dao==null){
29
30 dao=new userdata();
31 }
32 return dao;
33 }
34
35 public boolean login(String name,String pass){
36 try {
37 co=DriverManager.getConnection(url, user, password);
38 ps=co.prepareStatement("select name from uerinfo_table where name=? and password=?");
39 ps.setString(1, name);
40 ps.setString(2, pass);
41 ResultSet rs=ps.executeQuery();
42 while(rs.next()){
43
44 return true;
45 }
46
47 return false;
48 } catch (SQLException e) {
49 throw(new RuntimeException(e));
50 }
51
52 }
53
54 public void regist(String name,String pass){
55 try {
56 co=DriverManager.getConnection(url, user, password);
57 ps=co.prepareStatement("insert into uerinfo_table values(?,?)");
58 ps.setString(1, name);
59 ps.setString(2, pass);
60 ps.execute();
61
62 } catch (SQLException e) {
63 throw(new RuntimeException(e));
64 }
65
66 }
67
68 }