JSP用FOR迴圈表格顯示查出來的資料
- 2022-09-01
package mysqlconnection;
import java。io。FileInputStream;
import java。io。FileNotFoundException;
import java。io。IOException;
import java。sql。Connection;
import java。sql。DriverManager;
import java。sql。ResultSet;
import java。sql。SQLException;
import java。sql。Statement;
import java。util。ArrayList;
import java。util。List;
import java。util。Properties;
public class MySQLConnection {
private static Connection conn = null;
private static Connection conn1 = null;
static String url = null;
static String user = null;
static String password = null;
static {
Properties p = new Properties();
try {
p。load(new FileInputStream(“db/jie。properties”));
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e。printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e。printStackTrace();
}
url = p。getProperty(“url”);
user = p。getProperty(“username”);
password = p。getProperty(“password”);
}
private MySQLConnection() {
}
public static Connection getConnection() {
if (conn == null)
try {
conn = DriverManager。getConnection(url, user, password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e。printStackTrace();
}
return conn;
}
/**
* @param args
* @throws IOException
* @throws FileNotFoundException
*/
public static void main(String[] args) throws FileNotFoundException,
IOException {
//SQL語句
String sql = “select * from Account”;
String insert = “insert into account(username,password) values(‘gaoge’,‘gaoge’)”;
String delete = “delete from account where id > 4”;
try {
Class。forName(“com。mysql。jdbc。Driver”);
} catch (ClassNotFoundException e) {
e。printStackTrace();
}
conn1 = getConnection();
conn = getConnection();
System。out。println(conn。equals(conn1));
Statement st = null;
//用泛型初始化Account物件
List
Account account = null;
try {
st = conn。createStatement();
int count1 = st。executeUpdate(delete);
System。out。println(“刪除了:” + count1 + “個數據!”);
int count = st。executeUpdate(insert);
System。out。println(“插入了:” + count + “個數據!”);
//查詢出來的結果儲存在rs中
ResultSet rs = st。executeQuery(sql);
//用迴圈遍歷出rs中的內容
while (rs。next()) {
int id = rs。getInt(“id”);
String username = rs。getString(“username”);
String pass = rs。getString(“password”);
System。out。println(id + “ ” + username + “” + pass);
//將讀取的資料新增到物件中
account = new Account();
account。setId(id);
account。setUsername(username);
account。setPassword(pass);
//將物件新增到list中
list。add(account);
}
System。out。println(list。size());
} catch (SQLException e) {
e。printStackTrace();
} finally {
try {
conn。close();
} catch (SQLException e) {
e。printStackTrace();
}
}
}
}
i=0;
while(it。hasnext())
{
if (i%4==0)
{
out。print(“
”)
}
haha。getusername();
i++;
}
應該是這個樣子,好久不用jsp了
上一篇:首字加偏旁是什麼字
下一篇:凱迪拉克srx換機油多少錢