网站系统开发需要掌握的技术
HTML,CSS 语法,XTML,XML 和 XSLM, 客户端脚本,服务器端脚本,JavaScript 语法,flash 动画制作,GIF 动画制作,网页图片处理,Photoshop,数据库设计
源代码:
package pers.sun.user;
public class User {
private int id;
private String userName;
private String nickName;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getNickName() {
return nickName;
}
public void setNickName(String nickName) {
this.nickName = nickName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package pers.sun.user;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import pers.sun.database.Database;
import pers.sun.exception.UserException;
public class UserTool implements UserInterface {
@Override
public void add(User user) {
// 获得链接对象
Connection connect=Database.getConnection();
// 准备 sql 语句
String sql="select count(*) from t_user where username=?";
// 语句传输对象;
PreparedStatement prepared=null;
ResultSet result=null;
try {
prepared=connect.prepareStatement(sql);
prepared.setString(1, user.getUserName());
// 接受结果集
result=prepared.executeQuery();
// 遍历结果集
while(result.next()) {
if(result.getInt(1)>0) {
throw new UserException("用户已存在!");
}
}
sql="insert into t_user(username,password,nickname) value (?,?,?)";
prepared=connect.prepareStatement(sql);
prepared.setString(1, user.getUserName());
prepared.setString(2, user.getPassword());
prepared.setString(3, user.getNickName());
prepared.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(result);
Database.close(prepared);
Database.close(connect);
}
}
@Override
public void deleted(int id) {
// 获得链接对象
Connection connect=Database.getConnection();
String sql="delete from t_user where id = ?";
PreparedStatement prepare=null;
try {
prepare=connect.prepareStatement(sql);
prepare.setInt(1, id);
prepare.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(prepare);
Database.close(connect);
}
}
@Override
public void update(User user) {
Connection connect=Database.getConnection();
PreparedStatement prepare=null;
String sql="update t_user set password=?,nickname=? where id ?";
try {
prepare=connect.prepareStatement(sql);
prepare.setString(1, user.getPassword());
prepare.setString(2, user.getNickName());
prepare.setInt(3, user.getId());
prepare.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(prepare);
Database.close(connect);
}
}
@Override
public User lookup(String userName) {
Connection connect=Database.getConnection();
PreparedStatement prepare=null;
ResultSet result=null;
String sql="select * from t_user where username = ?";
User user=new User();
try {
prepare=connect.prepareStatement(sql);
prepare.setString(1, userName);
result=prepare.executeQuery();
while(result.next()) {
user.setId(result.getInt("id"));
user.setUserName(result.getString("username"));
user.setPassword(result.getString("password"));
user.setNickName(result.getString("nickname"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(result);
Database.close(prepare);
Database.close(connect);
}
return user;
}
@Override
public User lookup(int id) {
Connection connect=Database.getConnection();
String sql="select * from t_user where id = ?";
PreparedStatement prepare=null;
ResultSet result=null;
User user=new User();
try {
prepare=connect.prepareStatement(sql);
prepare.setInt(1, id);
result=prepare.executeQuery();
while(result.next()) {
user.setId(id);
user.setUserName(result.getString("username"));
user.setPassword(result.getString("password"));
user.setNickName(result.getString("nickname"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(result);
Database.close(prepare);
Database.close(connect);
}
return user;
}
@Override
public List lookup() {
Connection connect=Database.getConnection();
String sql="select * from t_user";
PreparedStatement prepare=null;
ResultSet result=null;
List users=new ArrayList();
User user=new User();
try {
prepare=connect.prepareStatement(sql);
result=prepare.executeQuery();
while(result.next()) {
user.setId(result.getInt("id"));
user.setUserName(result.getString("username"));
user.setPassword(result.getString("password"));
user.setNickName(result.getString("nickname"));
users.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
Database.close(result);
Database.close(prepare);
Database.close(connect);
}
return users;
}
}
package pers.sun.exception;
public class UserException extends RuntimeException{
public UserException() {
super();
// TODO Auto-generated constructor stub
}
public UserException(String message, Throwable cause, boolean enableSuppression, boolean writableStackTrace) {
super(message, cause, enableSuppression, writableStackTrace);
// TODO Auto-generated constructor stub
}
public UserException(String message, Throwable cause) {
super(message, cause);
// TODO Auto-generated constructor stub
}
public UserException(String message) {
super(message);
// TODO Auto-generated constructor stub
}
public UserException(Throwable cause) {
super(cause);
// TODO Auto-generated constructor stub
}
}
package pers.sun.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Database {
public static Connection getConnection() {
//1. 加载驱动
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
e.printStackTrace();
}
String user="root";
String password="sunyu";
String url="jdbc:mysql://localhost:3306/user_massage";
// 建立连接 .
//url 格式:JDBC: 子协议: 子名称 // 主机名: 端口 / 数据库名?属性名 = 属性值 &...
//2 创建连接对象 connection
Connection connection=null;
try {
connection= DriverManager.getConnection(url, user , password);
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
//3 关闭资源
//1 关闭 连接对象
public static void close(Connection connection) {
try {
if(connection != null) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//2 关闭 语句传输对象
public static void close(PreparedStatement preparedStatement) {
try {
if(preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
//3 关闭 结果集对象
public static void close(ResultSet resultset) {
try {
if(resultset != null) {
resultset.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
<%@ page language="java"contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
来源: http://www.bubuko.com/infodetail-2474185.html