JSP基础

用原生jsp和javabean实践小项目，理解model1的web开发.

关键代码

DBHelp类

public class DBHelper {
    private static final String driver = "com.mysql.jdbc.Driver";//数据库驱动
    private static final String url = "jdbc:mysql://localhost:3306/shopping?useUnicode=true&characterEncoding=UTF-8";
    private static final String username = "root";
    private static final String password = "root";
    private static Connection connection=null;
    static {
        try{
            Class.forName(driver);
        }catch (Exception ex){
            ex.printStackTrace();
        }
    }
    //单例模式返回数据库连接对象
    public static Connection getConnection() throws SQLException {
        if (connection==null){
            connection = DriverManager.getConnection(url,username,password);
            return connection;
        }
        return connection;
    }
    public static void main(String[] args){
        try {
            Connection connection = DBHelper.getConnection();
            if (connection!=null){
                System.out.printf("数据库连接正常");
            }else {
                System.out.printf("数据库连接异常");
            }
        }catch (SQLException ex){
            ex.printStackTrace();
        }
    }
}

逻辑类连接数据库以及sql语句

 Connection connection=null;
 PreparedStatement stmt=null;//一个代表预编译的SQL语句的对象。
//一个SQL语句被预先编译并存储在一个PreparedStatement对象中。然后这个对象可以用来有效地多次执行这个语句。
ResultSet rs= null;
connection= DBHelper.getConnection();
String sql = "select * from items;";
stmt = connection.prepareStatement(sql);
rs=stmt.executeQuery();