?? baseclass.java
字號:
import java.awt.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import javax.swing.table.*;
import java.text.*;
import javax.swing.text.*;
class DataBase//連接odbc的類
{
Connection cn=null;
Statement st;
ResultSet rs;
ResultSetMetaData rsmd;
DataBase()
{
String str="jdbc:odbc:HANBIN";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
System.out.println(e.getMessage());
}
try
{
cn=DriverManager.getConnection(str,"","");
}
catch(SQLException ee)
{
System.out.println(ee.getMessage());
}
}
public void GetResultSet(String s)//初始化記錄集
{
try
{
st=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=st.executeQuery(s);
rsmd=rs.getMetaData();
}catch(SQLException e){}
}
}
////設置表格Model
class ModleTable
{
DefaultTableModel model;
DataBase dbModel;
Vector head=new Vector();
//有開始列參數的表格
void getmodel(String s,int colBegin)
{
try
{
dbModel=new DataBase();
dbModel.GetResultSet(s);
Vector head=new Vector();
model=new DefaultTableModel()
{
public boolean isCellEditable(int row,int col)
{
return false;
}
};
for(int i=colBegin;i<dbModel.rsmd.getColumnCount();i++)
head.addElement(dbModel.rsmd.getColumnName(i+1));
model.setColumnIdentifiers(head);
while(dbModel.rs.next())
{
Vector data=new Vector();
for(int i=colBegin;i<dbModel.rsmd.getColumnCount();i++)
data.addElement(dbModel.rs.getString(i+1));
model.addRow(data);
}
dbModel.st.close();
}
catch(SQLException e){}
}
//有開始和結束列參數的表格
void getmodel(String s,int colBegin,int colEnd)
{
try
{
dbModel=new DataBase();
dbModel.GetResultSet(s);
Vector head=new Vector();
model=new DefaultTableModel()
{
public boolean isCellEditable(int row,int col)
{
return false;
}
};
for(int i=colBegin;i<colEnd;i++)
head.addElement(dbModel.rsmd.getColumnName(i+1));
model.setColumnIdentifiers(head);
while(dbModel.rs.next())
{
Vector data=new Vector();
for(int i=colBegin;i<colEnd;i++)
data.addElement(dbModel.rs.getString(i+1));
model.addRow(data);
}
dbModel.st.close();
}
catch(SQLException e){}
}
}
//固定列的表格
class LockTableModel extends ModleTable
{
int pushedColumn;
JButton b;
JTable tableOne,tableTwo;
JScrollPane scroll;
DefaultTableCellRenderer renderer;
LockTableModel(String str,int i,int num)
{
getmodel(str,i);
tableOne=new JTable(model);
getmodel(str,i+num);
tableTwo=new JTable(model);
//tableOne.getTableHeader().setUpdateTableInRealTime(false);
tableOne.setPreferredScrollableViewportSize(new Dimension(tableOne.getColumnModel().getColumn(0).getPreferredWidth()*num,tableOne.getPreferredSize().height));
tableOne.setAutoResizeMode(tableOne.AUTO_RESIZE_OFF);
tableTwo.setPreferredScrollableViewportSize(new Dimension(475,tableOne.getPreferredSize().height));
tableTwo.setSelectionModel(tableOne.getSelectionModel());
tableTwo.setAutoResizeMode(tableTwo.AUTO_RESIZE_OFF);
scroll=new JScrollPane(tableTwo);
scroll.setRowHeaderView(tableOne);
scroll.setCorner(JScrollPane.UPPER_LEFT_CORNER,tableOne.getTableHeader());
scroll.getViewport().setBackground(new Color(255,255,240));
scroll.getRowHeader().setBackground(new Color(255,255,240));
scroll.getVerticalScrollBar().setForeground(Color.red);
tableOne.getTableHeader().setBackground(new Color(255,255,230));
tableTwo.getTableHeader().setBackground(new Color(255,255,230));
tableOne.getTableHeader().setForeground(new Color(255,0,255));
tableTwo.getTableHeader().setForeground(new Color(255,0,255));
tableOne.setForeground(new Color(77,199,199));
tableTwo.setForeground(new Color(77,199,199));
scroll.setBorder(BorderFactory.createLoweredBevelBorder());
}
}
//formatText
class FormatText
{
JFormattedTextField ftf;
FormatText() throws ParseException
{
//DateFormat format = new SimpleDateFormat("yyyy--MMMM--dd");
//DateFormatter df = new DateFormatter(format);
MaskFormatter mf = new MaskFormatter("####-##-##");
//mf.setPlaceholderCharacter('_');
ftf = new JFormattedTextField(mf);
ftf.setColumns(10);
ftf.setBackground(Color.orange);
ftf.setBorder(BorderFactory.createMatteBorder(0,0,1,0,new Color(255,100,255)));
}
}
//介紹信的表格
class LockLetter extends LetterModel
{
int pushedColumn;
JButton b;
JTable tableOne,tableTwo;
JScrollPane scroll;
DefaultTableCellRenderer renderer;
LockLetter(String str,int i,int num)
{
getmodel(str,i);
tableOne=new JTable(model);
getmodel(str,i+num);
tableTwo=new JTable(model2);
//tableOne.getTableHeader().setUpdateTableInRealTime(false);
tableOne.setPreferredScrollableViewportSize(new Dimension(tableOne.getColumnModel().getColumn(0).getPreferredWidth()*num,tableOne.getPreferredSize().height));
tableOne.setAutoResizeMode(tableOne.AUTO_RESIZE_OFF);
tableTwo.setPreferredScrollableViewportSize(new Dimension(475,tableOne.getPreferredSize().height));
tableTwo.setSelectionModel(tableOne.getSelectionModel());
tableTwo.setAutoResizeMode(tableTwo.AUTO_RESIZE_OFF);
scroll=new JScrollPane(tableTwo);
scroll.setRowHeaderView(tableOne);
scroll.setCorner(JScrollPane.UPPER_LEFT_CORNER,tableOne.getTableHeader());
scroll.getViewport().setBackground(new Color(255,255,240));
scroll.getRowHeader().setBackground(new Color(255,255,240));
scroll.getVerticalScrollBar().setForeground(Color.red);
tableOne.getTableHeader().setBackground(new Color(255,255,230));
tableTwo.getTableHeader().setBackground(new Color(255,255,230));
tableOne.getTableHeader().setForeground(new Color(255,0,255));
tableTwo.getTableHeader().setForeground(new Color(255,0,255));
tableOne.setForeground(new Color(77,199,199));
tableTwo.setForeground(new Color(77,199,199));
//scroll.setBorder(BorderFactory.createLoweredBevelBorder());
}
}
class LetterModel//設置介紹信Model
{
DefaultTableModel model,model2;
DataBase base, dbModel2;
void getmodel(String s,int colBegin)
{
base=new DataBase();
base.GetResultSet(s);
Vector head=new Vector();
model=new DefaultTableModel()
{
public Class getColumnClass(int col)
{
Vector tep=new Vector();
tep.addElement(Boolean.FALSE);
for(int i=0;i<18;i++)
tep.addElement(""+i);
return tep.get(col).getClass();
}
public boolean isCellEditable(int row,int col)
{
if(col==0)
return true;
else
return false;
}
};
try
{
for(int i=colBegin;i<base.rsmd.getColumnCount();i++)
head.addElement(base.rsmd.getColumnName(i+1));
model.setColumnIdentifiers(head);
while(base.rs.next())
{
String ss=base.rs.getString(1).toString().trim();
Vector data=new Vector();
if(ss.equalsIgnoreCase("1"))
data.addElement(Boolean.TRUE);
else
data.addElement(Boolean.FALSE) ;
for(int i=colBegin+1;i<base.rsmd.getColumnCount();i++)
data.addElement(base.rs.getString(i+1));
model.addRow(data);
}
}
catch(SQLException e)
{
}
////////////////////////////////////
try
{
dbModel2=new DataBase();
dbModel2.GetResultSet(s);
Vector head2=new Vector();
model2=new DefaultTableModel()
{
public boolean isCellEditable(int row,int col)
{
return false;
}
};
for(int i=colBegin;i<dbModel2.rsmd.getColumnCount();i++)
head.addElement(dbModel2.rsmd.getColumnName(i+1));
model2.setColumnIdentifiers(head);
while(dbModel2.rs.next())
{
Vector data=new Vector();
for(int i=colBegin;i<dbModel2.rsmd.getColumnCount();i++)
data.addElement(dbModel2.rs.getString(i+1));
model2.addRow(data);
}
dbModel2.st.close();
}
catch(SQLException e){}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -