本人菜鸟一枚~~~调试如此简单的代码还调了一天,发出来纪念一下,当然更希望能帮助到大家。
final String DBDRIVER =“org.gjt.mm.mysql.Driver”;
final String DBURL ="jdbc:mysql://localhost:3306/mldn";
final String DBUSER ="root";
final String DBPASS ="*****";
%>
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
%>
try{
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql="SELECT empno,ename,job,sal FROM emp";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
%>
编号 | 姓名 | 工作 | 工资 |
while(rs.next()){
int empno=rs.getInt(1);
System.out.println(empno);
S