列表/t...
cellspacing="1" bordercolor="#0000FF" bgcolor="#CCFF66" >
列表/td>姓名性别ID号地址联系方式Class.forName("com.mysql.jdbc.Driver");
String userName="root";
String userPasswd="root";
String dbName="lsh";
String tableName="mytable";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Connection connection = DriverManager.getConnection(url, userName, userPasswd);
if(!connection.isClosed())
System.out.println(" 商品信息列表:");
// statement用来执行SQL语句
Statement statement = connection.createStatement();
// 要执行的SQL语句
String sql="SELECT * FROM "+tableName;
// 执行SQL语句并返回结果集
ResultSet rs = statement.executeQuery(sql);
while(rs.next()) {
// 选择id这列数据
int ID =rs.getInt("ID");
// 选择name这列数据
String name= rs.getString("name");
// 选择price这列数据
int sex = rs.getInt("sex");
// 选择status这列数据
String address = rs.getString("address");
String telphone = rs.getString("telphone");
// 输出结果
out.println("
"+name+" "+sex+" "+ID+" "+address+""+telphone+" ");}
展开