Java Web基础登陆注册代码

//JDBC_BBS.java import java.sql.*; public class JDBC_BBS { public static void main(String[] args) { try { Class.forName("com.mysql.jdbc.Driver");// 注册MySQL 的驱动 } catch (ClassNotFoundException e) { e.printStackTrace(); } // 先定义变量，后使用和关闭 Connection conn = null;// 数据库连接 Statement stmt = null;// 数据库表达式 ResultSet rs = null;// 结果集 try { // 获取数据库的连接 conn = java.sql.DriverManager .getConnection( "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=GBK", "root", "root"); // root是用户名，密码为root,编码为GBK // 获取表达式 stmt = conn.createStatement(); stmt.executeUpdate("drop table student");// 删除表student stmt.executeUpdate("drop table discuss");// 删除表discuss stmt.executeUpdate("drop table reply");// 删除表reply // 创建表student stmt .executeUpdate("create table student(id int not null auto_increment," + "username varchar(20) unique," + "password varchar(20) not null," + "sex varchar(8) not null," + "age varchar(4) ," + "birth varchar(20) not null," + "telephone varchar(12)," + "email varchar(40) not null," + "primary key (id))"); // 创建表discuss stmt.executeUpdate("create table discuss(name char(20) not null," + "email char(40) not null," + "subject char(60) not null," + "content text not null," + "time char(40)," + "username char(20)," + "id int not null auto_increment,primary key (id))"); // 创建表reply stmt.executeUpdate("create table reply(name char(20) not null," + "content text not null," + "time char(40),reply int," + "id int not null auto_increment," + "primary key (id))"); stmt .executeUpdate("insert into discuss(name,email,subject,content,time,username) values('FrogKing', 'menghuan277717@163.com','Test','The first input data!','2009年4月18日18：30：30','FrogKing')"); // 执行插入数据的 SQL stmt .executeUpdate("insert into Student(username,password,sex,age,birth,telephone,email) values('Tome', '1234','男',20,'','13820991219','menghuan277717@163.com')"); stmt .executeUpdate("insert into Student(username,password,sex,age,birth,telephone,email) values('Bell', '1234','男',20,'','13820991219','menghuan277717@163.com')"); stmt .executeUpdate("insert into Student(username,password,sex,age,birth,telephone,email) values('Jack', '1234','男',20,'','13820991219','menghuan277717@163.com')"); stmt .executeUpdate("insert into Student(username,password,sex,age,birth,telephone,email) values('FrogKing', '123456','男',20,'','13820991219','menghuan277717@163.com')"); } catch (SQLException e) { e.printStackTrace(); } finally {// 释放资源 // try { // rs.close(); // } catch (SQLException e) { // } try { stmt.close(); } catch (SQLException e) { } try { conn.close(); } catch (SQLException e) { } } } }