题目描述
使用MySQL数据库
建立数据库名称:jsp
建立数据表:inf(id,name,pwd,age,gender)
create table inf
(id int primary key auto_increment,
name char(20) not null,
pwd char(20) not null,
age int not null,
gender char(2) not null) default charset=utf8;
用户登录,输入用户名与密码(如图一)
用户名与密码需要到数据库验证,如果验证错误,提示错误信息(如图二
),点击“注册”,跳转到“注册”页面(如图四),把用户名,密码,年龄,性别 这些信息,添加到数据库,点击,“返回登录”,回到登录页面,重新输入用户名,密码,登录成功后,进入“显示数据页面”,把数据表中的所有信息显示出来(如图三 )
代码
使用myEclipse,建立与mySQL之间的连接
首先在Navicat 中新建数据库 jsp,新建表如下:
建立连接:
package com.sy.util;
import java.sql.*;
public class DBUtil {
public static Connection getConnection(){
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("未找到驱动类!");
}
try {
String url = "jdbc:mysql://localhost:3306/jsp";
conn = DriverManager.getConnection(url, "root","123456");
} catch (SQLException e) {
e.printStackTrace();
System.out.println("数据库服务器异常,数据连接错误!");
}
return conn;
}
public static void closeAll(ResultSet rs,Statement stmt,PreparedStatement pstmt,Connection conn){
try {
if(rs != null){
rs.close();
}
if(stmt != null){
stmt.close();
}
if(pstmt != null){
pstmt.close();
}
if(conn != null){
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args){
Connection conn = DBUtil.getConnection();
System.out.println(conn != null ? "连接成功!" : "连接失败!");
}
}
实体类:
package com.sy.entity;
public class Inf {
private int id;
private String name;
private String pwd;
private int age;
private String gender;
public Inf(){
}
public Inf(String name, String pwd,int age,String gender) {
super();
this.name = name;
this.pwd = pwd;
this.age = age;
this.gender = gender;
}
public Inf(int id, String name, String pwd,int age,String gender) {
this.id = id;
this.name = name;
this.pwd = pwd;
this.age = age;
this.gender = gender;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String toString(){
return this.id+"\t"+this.name+"\t"+this.pwd+"\t"+this.age+"\t"+this.gender;
}
}
Dao:
package com.sy.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import com.sy.util.*;
import com.sy.entity.*;
public class InfDao {
private static Connection conn = null;
private static Statement stmt = null;
private static PreparedStatement pstmt = null;
private static ResultSet rs = null;
public Inf queryByName(String name){
Inf inf=null;
try