| 标题 | jsp调用java类并查询sql数据库 |
| 内容 | jsp教程调用java类并查询sql数据库教程 package bean; import java.sql.*; public class MyDb_Page{ private Statement stmt; private Connection conn=null; private ResultSet rs=null; private String navi; public void connection(String db_name,String user,String pwd) throws Exception{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url="jdbc:mysql教程://www.update8.com:3306/" + db_name; conn=DriverManager.getConnection(url,user,pwd); stmt=conn.createStatement(); } public ResultSet query(String sql) throws Exception{ rs=stmt.executeQuery(sql); return rs; } public ResultSet query(String query,int size,int page) throws Exception{ int page_count; //总页数 int result_count; //总记录数 int begin; //当前页第一条记录索引号 String sql=query; int i=query.indexOf("from"); String sql2=query.substring(i); rs=query("select count(*) " + sql2); rs.next(); result_count=rs.getInt(1); page_count=(result_count + size - 1)/size; begin=(page-1)*size; String s=" limit " + begin + "," +size; sql=sql + s; rs=query(sql); //设置导航栏 String back="没有了"; String pre="没有了"; if(page>1) back="<a href=?page=" + String.valueOf(page-1) + ">上一页</a>"; if(page<page_count) pre="<a href=?page=" + String.valueOf(page+1) + ">下一页</a>"; navi=back + " " + pre; return rs; } public String getNavi(){ return navi; } public int update(String sql) throws Exception{ int n=0; n=stmt.executeUpdate(sql); return n; } public boolean delete(String sql) throws Exception{ boolean flag=false; flag=stmt.execute(sql); return flag; } } %> <jsp:useBean id="www.update8.com" scope="page"/> <% String sql="select * from student"; ResultSet rs=db.query(sql); while(rs.next()){ out.println(rs.getString(10); } |
| 随便看 |
|
在线学习网考试资料包含高考、自考、专升本考试、人事考试、公务员考试、大学生村官考试、特岗教师招聘考试、事业单位招聘考试、企业人才招聘、银行招聘、教师招聘、农村信用社招聘、各类资格证书考试等各类考试资料。