Stringpath=request.getContextPath();StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>
">
My JSP ‘index.jsp‘ starting page//声明Connection对象
Connection con;//驱动程序名Stringdriver= "com.mysql.jdbc.Driver";//URL指向要访问的数据库名mydataStringurl= "jdbc:mysql://localhost:3306/USERINFO";//MySQL配置时的用户名Stringuser= "root";//MySQL配置时的密码Stringpassword= "699307";//遍历查询结果集
Connection conn= null;
try {//加载驱动程序
Class.forName(driver);//1.getConnection()方法,连接MySQL数据库!!
conn=DriverManager.getConnection(url,user,password);if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");//2.创建statement类对象,用来执行SQL语句!!
Statement st=conn.createStatement();//执行sql语句Stringsql= "select * from USERINFO";//增删改查表中的内容,用executeUpdate方法
st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (1, ‘NOSTRING‘)");
st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (2, ‘BECHAR‘)");
st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (3, ‘ALEXVIEW‘)");//读取表的内容,用executeQuery方法
ResultSet rs=st.executeQuery("select * from USERINFO");//循环输出内容while(rs.next()){intuserID=rs.getInt(1);Stringusername=rs.getString(2);
out.println("-------------------
");
out.println("uerid:"+userID+"
");
out.println("username:"+username+"
");
out.println("-------------------
");
}
}catch(SQLException e){
out.print(e.getErrorCode()+ "
");
out.print(e.getCause()+ "
");
out.print(e.getMessage()+ "
");if(conn != null)
conn.close();
}%>