JAVA单链表学生成绩管理
发布网友
发布时间：2022-05-23 16:07
共3个回答
热心网友
时间：2023-10-28 12:58
import java.awt.*;
import java.sql.*;
import javax.swing.*;
public class DB extends JFrame
{
privateJTextArea jta= new JTextArea();
private String url="jdbc:sqlserver://127.0.0.1;DatabaseName=studentDB";
privateString user="sa";
privateString password="xiner";
privateString strSQL="select * from S";
publicDB()
{
add(newJLabel("查询结果："),BorderLayout.NORTH);
add(jta);
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
jta.append("Connectionsuccess. \n");
try {
Connectionconn=DriverManager.getConnection(url,user,password);
jta.append("Loadingdriver success. \n");
Statementst = conn.createStatement();
jta.append("CreatingStatement success. \n");
ResultSetrs = st.executeQuery(strSQL);
jta.append("CreatingResultSet success. \n\n");
Stringtemp="";
jta.append("SNO"+"\t"+"SNAME"+"\t"+"SDEPA"+"\t"+"SAGE"+"\t"+"SSEX\n\n");
while(rs.next())
{
temp+=rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t"+rs.getObject(4)+"\t"+rs.getObject(5)+"\n";
}
jta.append(temp);
}catch (SQLException e) {
e.printStackTrace();
}
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
publicstatic void main(String[] args)
{
DB frame=new DB();
frame.setDefaultCloseOperation(3);
frame.setTitle("DB");
frame.setSize(400,320);
frame.setVisible(true);
}
}
主体大概是这样，自己再改改
热心网友
时间：2023-10-28 12:58
热心网友
时间：2023-10-28 12:58
