java连接mysql数据库jsp

4、连接数据库

4、1导入jar包

/WebRoot/WEB-INF/lib/mysql-connector-java-5.1.5-bin.jar

4.2写代码

request.setCharacterEncoding("utf-8"); //设置表单为utf-8，否则会中文乱码

try {  
            Class.forName("com.mysql.jdbc.Driver");  ////驱动程序名
            String db_url = "jdbc:mysql://localhost:3306/java_school"; //数据库名
            String db_name = "root";  //数据库用户名
            String db_pwd = "root";  //数据库用户密码
            Connection conn = DriverManager.getConnection(db_url, db_name, db_pwd);  //连接状态

            if(conn != null){  
                //out.print("数据库连接成功！");  
                out.print("<br />");            
                Statement stmt = null;  
                ResultSet rs = null;  
                String sql = "SELECT *FROM user where uname = '"+username+"' and pwd = '"+pwd+"' ";  //查询语句
                stmt = conn.createStatement();  
                rs = stmt.executeQuery(sql);  
                /*out.print("查询结果：");  
                out.print("<br />");  
                out.println("姓名"+"  "+"性别 "+"  "+"年龄" +" " + "密码");  
                out.print("<br />");  
                while (rs.next()) {  
                out.println(rs.getString("uname")+"   &nbsp  "+rs.getString("sex")+"  &nbsp "+rs.getInt("age")+"  &nbsp "+rs.getString("pwd")); //将查询结果输出
                out.print("<br />");   
            } 
            */ 
            if(rs.next()){
             out.print("登陆成功！");  
            }else{
            out.print("登陆失败！");
            }
            }
            else{  
                out.print("连接失败！");  
            }  
        }catch (Exception e) {        
            out.print("数据库连接异常！");  
        }