Code khachs hang
package khachhang;
import [Link];
public class KhachHang {
public String MaKH;
public String teKH;
public String email;
public String soTK;
public KhachHang() {
}
public KhachHang(String MaKH, String teKH, String email, String soTK) {
[Link] = MaKH;
[Link] = teKH;
[Link] = email;
[Link] = soTK;
}
public String getMaKH() {
return MaKH;
}
public String getTeKH() {
return teKH;
}
public String getEmail() {
return email;
}
public String getSoTK() {
return soTK;
}
public void setMaKH(String MaKH) {
[Link] = MaKH;
}
public void setTeKH(String teKH) {
[Link] = teKH;
}
public void setEmail(String email) {
[Link] = email;
}
public void setSoTK(String soTK) {
[Link] = soTK;
}
void nhap()
{
Scanner sc=new Scanner([Link]);
[Link]("Nhap ma:");
MaKH=[Link]();
[Link]("Nhap ten:");
teKH=[Link]();
[Link]("Nhap email:");
email=[Link]();
[Link]("Nhap so tk:");
soTK=[Link]();
}
void xuat()
{
[Link]("\t\t"+MaKH+"\t\t"+teKH+"\t\t"+email+"\t\t"+soTK);
}
void sapxep(KhachHang[] a)
{
for(int i=0;i<[Link];i++)
{
for(int j=1;j<=[Link];j++){
// if(a[j].teKH<a[i].teKH)
{
KhachHang temp=a[i];
a[i]=a[j];
temp=a[j];
}
}
}
}
}
@code danh sách
package khachhang;
import [Link];
public class DanhSach {
public static void main(String[] args) {
Scanner sc=new Scanner([Link]);
[Link]("Nhap so luong khach hang:");
int n=[Link]();
KhachHang[] a=new KhachHang[n];
a=new KhachHang[n];
[Link]("Danh sach khach hang");
for(int i=0;i<n;i++)
{
a[i]=new KhachHang();
a[i].nhap();
}
for(int i=0;i<n;i++)
{
a[i].xuat();
}
[Link]("Danh sachh sap xep theo ten");
for(int i=0;i<n;i++)
{
a[i].xuat();
}
}
}
Code qly trưởng nhóm có class lạptrinh
@LapTrinh
package qltailieu.cau1 ();
import [Link];
public class LapTrinh {
private String hoten;
private int namSinh;
int hsl;
public LapTrinh() {
}
public LapTrinh(String hoten, int namSinh, int hsl) {
[Link] = hoten;
[Link] = namSinh;
[Link] = hsl;
}
public String getHoten() {
return hoten;
}
public void setHoten(String hoten) {
[Link] = hoten;
}
public int getNamSinh() {
return namSinh;
}
public void setNamSinh(int namSinh) {
[Link] = namSinh;
}
public int getHsl() {
return hsl;
}
public void setHsl(int hsl) {
[Link] = hsl;
}
public void nhap()
{
Scanner sc = new Scanner([Link]);
[Link]("Nhap ho ten: ");
hoten = [Link]();
[Link]("Nhap nam sinh: ");
namSinh = [Link]();
[Link]("Nhap he so luong: ");
hsl = [Link]();
}
public void xuat()
{
[Link]("Ho ten: " + hoten);
[Link]("Nam sinh: " + namSinh);
[Link]("He so luong: " + hsl);
}
}
@class truong nhom
package qltailieu.cau1 () ();
import [Link];
public class TruongNhom extends LapTrinh{
private int Ltn;
private int Snct;
public TruongNhom (){
public TruongNhom(int Ltn, int Snct) {
[Link] = Ltn;
[Link] = Snct;
}
public TruongNhom(int Ltn, int Snct, String hoten, int namSinh, int hsl) {
super(hoten, namSinh, hsl);
[Link] = Ltn;
[Link] = Snct;
}
public int getLtn() {
return Ltn;
}
public void setLtn(int Ltn) {
[Link] = Ltn;
}
public int getSnct() {
return Snct;
}
public void setSnct(int Snct) {
[Link] = Snct;
}
@Override
public void nhap()
{
Scanner sc = new Scanner([Link]);
[Link]();
[Link]("Nhap so luong trach nhiem: ");
Ltn = [Link]();
[Link]("Nhap so nam cong tac : ");
Snct = [Link]();
}
@Override
public void xuat() {
[Link]();
[Link]("So luong trach nhiem: " + Ltn);
[Link]("So nam cong tac: " + Snct);
}
public double tinhLuong () {
return hsl*1800000+Snct*9000+Ltn;
}
}
@hàm main
package qltailieu.cau1 () ();
import [Link];
public class Main {
public static void main(String[] args) {
Scanner sc= new Scanner([Link]);
int n;
[Link]("--> Nhap so truong nhom : ");
n= [Link]();
TruongNhom [] ds= new TruongNhom[n];
[Link]("--------------------------");
[Link]("[Link] vao danh sach "+n+" truong nhom.");
for (int i = 0; i < n; i++) {
[Link]("? Nhap danh sach truong nhom thu "+(i+1));
ds[i]= new TruongNhom();
ds[i].nhap();
}
[Link]("--------------------------");
[Link]("[Link] thi danh sach "+n+" truong nhom.");
for (int i = 0; i < n; i++) {
ds[i].xuat();
}
[Link]("--------------------------");
[Link]("[Link] thi danh sach truong nhom giam dan.");
TruongNhom tg = new TruongNhom();
for (int i = 0; i < n-1; i++) {
for (int j = i+1; j < n; j++) {
if(ds[i].tinhLuong()<ds[j].tinhLuong()){
tg= ds[i];
ds[i]=ds[j];
ds[j]=tg;
}
}
}
for (int i = 0; i < 1; i++) {
ds[i].xuat();
}
}}
Form Qly Mtinh
@class ketnoi i
package javathanh;
import [Link].*;
import [Link].*;
import [Link];
import [Link];
import [Link];
public class ketnoi {
public static Connection KNCSDL() throws SQLException , ClassNotFoundException
{
Connection c=[Link]("jdbc:mysql://localhost:3306/qltailieu","root","");
[Link]("[Link]");
return c;
}
@class testconnect
package javathanh;
import [Link].*;
import [Link].*;
import [Link];
import [Link];
import [Link];
import [Link];
public class testconnect {
public static void main(String[] args) {
try {
Connection kn=[Link]();
if(kn==null){
[Link]("Ket noi that bai ");
}
else{
[Link]("Ket noi thanh cong ");
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
}
}
}
@code Jform
package javathanh;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class JFmaytinh extends [Link] {
public JFmaytinh() {
initComponents();
}
@SuppressWarnings("unchecked")
private void initComponents() {
}
private void txt_maActionPerformed([Link] evt) {
}
private void btxoaActionPerformed([Link] evt) {
String ma="";
int selectedRow=[Link]();
if(selectedRow!=-1)
{
ma=[Link](selectedRow, 0).toString();
}else
{
[Link](null, "vui long chon hoc vien muon xoa", "Sum", JOptionPane.INFORMATION_MESSAGE);
}
try {
Connection kn=[Link]();
String xoa="DELETE FROM tt_talieu WHERE matl='"+ma+"'";
Statement stm= [Link]();
[Link](xoa);
String sql1= "Select * from tt_talieu";
ResultSet rs= [Link](sql1);
DefaultTableModel dtm= (DefaultTableModel) [Link]();
[Link](0);
while([Link]())
{
Object objliss[]=
{
[Link](1),
[Link](2),
[Link](3),
[Link](4)
};
[Link](objliss);
[Link](dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
} // TODO add your handling code here:
}
private void JbLaydulieuActionPerformed([Link] evt) {
try {
Connection kn=[Link]();
//Khai bao cau lenh de tra ve cac ban ghi trong csdl; /
String sqll="select * from tt_talieu";
//Khai bao doi tuong Statement de thuc thi cau lenh;
Statement stm=[Link]();
//thuc thi cau lenh sql va tra ve cac ban ghi tromg csdl;
ResultSet rs=[Link](sqll);
DefaultTableModel dtm=(DefaultTableModel) [Link]();
[Link](0);
//doc va hien thi len bang;
while([Link]())
{
Object objliss[]={
[Link](1),
[Link](2),
[Link](3),
[Link](4)
};
//dua objliss vao dtm
[Link](objliss);
[Link](dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
} // TODO add your handling code here:
}
private void JbLaydulieuMouseClicked([Link] evt) {
try {
Connection kn=[Link]();
//Khai bao cau lenh de tra ve cac ban ghi trong csdl; /
String sqll="select * from tt_talieu";
//Khai bao doi tuong Statement de thuc thi cau lenh;
Statement stm=[Link]();
//thuc thi cau lenh sql va tra ve cac ban ghi tromg csdl;
ResultSet rs=[Link](sqll);
DefaultTableModel dtm=(DefaultTableModel) [Link]();
[Link](0);
//doc va hien thi len bang;
while([Link]())
{
Object objliss[]={
[Link](1),
[Link](2),
[Link](3),
[Link](4)
};
//dua objliss vao dtm
[Link](objliss);
[Link](dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
} // TODO add your handlin// TODO add your handling code here:
}
private void JbthemActionPerformed([Link] evt) {
String ma=txt_ma.getText();
String ten=txt_ten.getText();
String sxb=txt_hdh.getText();
String trang=txt_hang.getText();
try {
Connection kn=[Link]();
String sql2 = "insert into tt_talieu values('"+ma+"','"+ten+"','"+sxb+"','"+trang+"')" ;
//khai bao doi tuong statement de thuc thi cau lenh sql;
Statement stm = [Link]();
//thuc thi cau lenh sql2;
[Link](sql2);
//doc cac ban ghi trong csdl sau khi them vao bang tren from;
String sql1="select * from tt_talieu ";
ResultSet rs = [Link](sql1);
DefaultTableModel dtm= (DefaultTableModel) [Link]();
[Link](0);
//doc rs va hien thi len bang
while([Link]()){
Object objlist[]={
[Link](1),
[Link](2),
[Link](3),
[Link](4)
};
[Link](objlist);
[Link](dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
}// TODO add your handling code here:
}
private void btsuaActionPerformed([Link] evt) {
try {
String macansua=txt_ma.getText();
String tensua=txt_ten.getText();
String sxbsua=txt_hdh.getText();
String trangsua=txt_hang.getText();
Connection kn= [Link]();
String sqlsua="update tt_talieu set tentl='" +tensua+"',soxb='"+sxbsua+"',sotrang='" +trangsua+ "' where matl='"+macansua+"' ";
//khai bao
Statement stm= [Link]();
//thuc thi
[Link](sqlsua);
//dua cac ban ghi trong bang csdl len table sau khi da cap nhap;
String sql1="select *from tt_talieu";
//thuc thi cau lenh sql tren;
ResultSet rs= [Link](sql1);
DefaultTableModel dtm=(DefaultTableModel) [Link]();
[Link](0);
//doc rs va dua hien thi len bang
while([Link]())
{
Object objliss[]={
[Link](1),
[Link](2),
[Link](3),
[Link](4),
};
[Link](objliss);
[Link](dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
} // TODO add your handling code here:
}
private void tbMouseClicked([Link] evt) {
int row=[Link]();
//lay du lieu o tung cot trong hang vua chon;
String ma=[Link](row,0).toString();
String ten=[Link](row,1 ).toString();
String dc=[Link](row,2).toString();
String tn=[Link](row,3).toString();
//dua du lieu cua tung cot trong hang da chon len textfield;
txt_ma.setText(ma);
txt_ten.setText(ten);
txt_hdh.setText(dc);
txt_hang.setText(tn);// TODO add your handling code here:
}
private void btthoatActionPerformed([Link] evt) {
[Link](0); // TODO add your handling code here:
}
private void bttkiemActionPerformed([Link] evt) {
String matim =txt_matk.getText();
try {
Connection kn=[Link]();
//khai bao câu lệnh sql để trả về các bản ghi trong csdl
//khai bao câu lệnh sql để trả về các bản ghi trong csdl
String sql1="select*from tt_talieu where matl ='"+matim+"'";
//khai bao doi tuong Statement để thực thi câu lệnh sql
Statement stm=[Link]();
//thực thi câu lệnh sql và trả về các bản ghi trong csdl
ResultSet rs= [Link](sql1);
DefaultTableModel dtm=(DefaultTableModel) [Link]();
[Link](0);
//doc rs và hiển thị lên bảng
while([Link]()){
Object objliss[]={
[Link](1),
[Link](2),
[Link](3),
[Link](4),
};
//Đưa objliss vào dtm
[Link](objliss);
[Link]((TableModel) dtm);
}
} catch (SQLException ex) {
[Link]([Link]()).log([Link], null, ex);
}
public static void main(String args[]) {
try {
for ([Link] info : [Link]()) {
if ("Nimbus".equals([Link]())) {
[Link]([Link]());
break;
}
}
} catch (ClassNotFoundException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch (InstantiationException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch (IllegalAccessException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch ([Link] ex) {
[Link]([Link]()).log([Link], null, ex);
}
//</editor-fold>
[Link](new Runnable() {
public void run() {
new JFmaytinh().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] JbLaydulieu;
private [Link] Jbthem;
private [Link] btsua;
private [Link] btthoat;
private [Link] bttkiem;
private [Link] btxoa;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel4;
private [Link] jLabel5;
private [Link] jLabel6;
private [Link] jScrollPane1;
private [Link] tb;
private [Link] txt_hang;
private [Link] txt_hdh;
private [Link] txt_ma;
private [Link] txt_matk;
private [Link] txt_ten;
// End of variables declaration
}
