java代码 用户信息修改与删除
package tushuguanli;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import java.awt.*;
import javax.swing.table.*;
import java.util.*;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.tree.DefaultTreeModel;
import javax.swing.tree.TreeSelectionModel;
import javax.swing.ButtonGroup;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;
public class Yhxxxgysc {
/**
* @param args
*/
public static void main(String[] args)
{
Yhxxxgysc_1 frame=new Yhxxxgysc_1();
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setVisible(true);
}
}
class Yhxxxgysc_1 extends JFrame
{
private static final int AUTO_RESIZE_OFF=0;
Yhxxxgysc_1()
{
setTitle("用户信息修改与删除");
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setVisible(true);
Toolkit tk = Toolkit.getDefaultToolkit();
Dimension screenSize = tk.getScreenSize();
int screenHeight = screenSize.height;
int screenWidth = screenSize.width;
setSize(screenWidth, screenHeight);
Container contentPane = getContentPane();
setLocationRelativeTo(null);
contentPane.setLayout(null);
myTable=new DefaultTableModel();
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:53104;DatabaseName=tushuguan;",
"sa", "123");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from yhxx");//xx为自己建的表的名称
ResultSetMetaData metaData;
metaData = rs.getMetaData();
number=metaData.getColumnCount();
columnNames=new Vector();
rows=new Vector>();
for(int num=0;num
{
columnNames.addElement(metaData.getColumnLabel(num