
import java.io.*
import java.net.*
import java.sql.*
import java.lang.*
import javax.sql.*
import java.awt.*
import java.awt.event.*
import javax.swing.*
import com.borland.jbcl.layout.*
public class delbook extends JFrame {
JPanel contentPane
XYLayout xYLayout1 = new XYLayout()
JLabel jLabel1 = new JLabel()
JLabel jLabel2 = new JLabel()
JLabel jLabel3 = new JLabel()
JTextField jTextField1 = new JTextField()
JLabel jLabel4 = new JLabel()
JTextField jTextField2 = new JTextField()
JLabel jLabel5 = new JLabel()
JTextField jTextField3 = new JTextField()
JLabel jLabel6 = new JLabel()
JTextField jTextField4 = new JTextField()
JButton jButton1 = new JButton()
//Construct the frame
public delbook() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK)
try {
jbInit()
}
catch(Exception e) {
e.printStackTrace()
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel) this.getContentPane()
jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel1.setForeground(Color.red)
contentPane.setLayout(xYLayout1)
this.setSize(new Dimension(500,400))
this.setTitle("超市管理系统")
jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30))
jLabel2.setText("业务单位信息")
jLabel3.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel3.setText("产品编号")
jTextField1.setText("")
jLabel4.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel4.setText("公司名称")
jTextField2.setText("")
jLabel5.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel5.setText("订单号码")
jTextField3.setText("")
jLabel6.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel6.setText("电 话")
jTextField4.setText("")
jButton1.setFont(new java.awt.Font("SansSerif", 0, 25))
jButton1.setText("提交")
jButton1.addActionListener(new delbook_jButton1_actionAdapter(this))
contentPane.add(jLabel1, new XYConstraints(179, 1, 153, 32))
contentPane.add(jLabel2, new XYConstraints(162, 33, -1, -1))
contentPane.add(jLabel3, new XYConstraints(83, 89, -1, -1))
contentPane.add(jTextField1, new XYConstraints(189, 88, 141, 36))
contentPane.add(jTextField2, new XYConstraints(189, 149, 142, 36))
contentPane.add(jLabel4, new XYConstraints(84, 148, -1, -1))
contentPane.add(jTextField3, new XYConstraints(188, 206, 143, 33))
contentPane.add(jLabel5, new XYConstraints(84, 204, -1, -1))
contentPane.add(jLabel6, new XYConstraints(84, 253, -1, -1))
contentPane.add(jTextField4, new XYConstraints(189, 260, 143, 36))
contentPane.add(jButton1, new XYConstraints(197, 318, -1, -1))
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e)
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0)
}
}
void update() {
try {
//定义显示的字符串
String str1
String str2
String str3
String str4
str1 = jTextField1.getText()
str2 = jTextField2.getText()
str3 = jTextField3.getText()
str4 = jTextField4.getText()
//装载jdbc驱动程序
String driverName = "oracle.jdbc.OracleDriver"
Driver driver = (Driver) Class.forName(driverName).newInstance()
//连接数据库
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@thsspc0791:1521:liuyong", "hr", "tongfang")
PreparedStatement pstmt = con.prepareStatement(
" insert Customer1('goodID','Name','PID','tel')values(?,?,?,?)")
pstmt.setString(1, str1)
pstmt.setString(2, str2)
pstmt.setString(1, str3)
pstmt.setString(4, str4)
ResultSet res = pstmt.executeQuery()
pstmt.close()
con.close()
}catch (InstantiationException e) {
System.out.println(e.getMessage())
}catch (IllegalAccessException e) {
System.out.println(e.getMessage())
}catch (ClassNotFoundException e) {
System.out.println(e.getMessage())
}catch (SQLException edd) {
edd.printStackTrace()
System.out.println(edd.getMessage())
}
}
void jButton1_actionPerformed(ActionEvent e) {
update()
}
}
class delbook_jButton1_actionAdapter implements java.awt.event.ActionListener {
delbook adaptee
delbook_jButton1_actionAdapter(delbook adaptee) {
this.adaptee = adaptee
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e)
}
}
package untitled5
import java.awt.*
import java.awt.event.*
import javax.swing.*
import com.borland.jbcl.layout.*
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright © 2003</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/
public class retur extends JFrame {
JPanel contentPane
XYLayout xYLayout1 = new XYLayout()
JLabel jLabel1 = new JLabel()
//Construct the frame
public retur() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK)
try {
jbInit()
}
catch(Exception e) {
e.printStackTrace()
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel) this.getContentPane()
jLabel1.setFont(new java.awt.Font("SansSerif", 0, 20))
jLabel1.setForeground(Color.red)
jLabel1.setText("超市管理系统")
contentPane.setLayout(xYLayout1)
this.setSize(new Dimension(400, 300))
this.setTitle("超市管理系统")
contentPane.add(jLabel1, new XYConstraints(139, 1, 126, 33))
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e)
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0)
}
}
}
package untitled5
import java.io.*
import java.net.*
import java.sql.*
import java.lang.*
import javax.sql.*
import java.awt.*
import java.awt.event.*
import javax.swing.*
import com.borland.jbcl.layout.*
import com.borland.dbswing.*
//货品信息登记
public class Frame2 extends JFrame {
JPanel contentPane
JLabel jLabel1 = new JLabel()
XYLayout xYLayout1 = new XYLayout()
JLabel jLabel2 = new JLabel()
JLabel jLabel3 = new JLabel()
JTextField jTextField1 = new JTextField()
JLabel jLabel4 = new JLabel()
JTextField jTextField2 = new JTextField()
JPanel jPanel1 = new JPanel()
XYLayout xYLayout2 = new XYLayout()
JScrollPane jScrollPane1 = new JScrollPane()
JLabel jLabel5 = new JLabel()
JTextField jTextField3 = new JTextField()
//Construct the frame
public Frame2() {
enableEvents(AWTEvent.WINDOW_EVENT_MASK)
try {
jbInit()
}
catch(Exception e) {
e.printStackTrace()
}
}
//Component initialization
private void jbInit() throws Exception {
contentPane = (JPanel) this.getContentPane()
contentPane.setLayout(xYLayout1)
this.setSize(new Dimension(600, 500))
this.setTitle("超市管理系统")
this.addHierarchyBoundsListener(new Frame2_this_hierarchyBoundsAdapter(this))
jLabel1.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel1.setForeground(Color.red)
jLabel1.setText("超市管理系统")
contentPane.setForeground(Color.black)
jLabel2.setFont(new java.awt.Font("SansSerif", 0, 30))
jLabel2.setText("产 品 信 息 展 示")
// statusBar.setFont(new java.awt.Font("SansSerif", 0, 20))
jLabel3.setFont(new java.awt.Font("SansSerif", 0, 20))
jLabel3.setText("产品名称")
jTextField1.setText("")
jLabel4.setEnabled(true)
jLabel4.setFont(new java.awt.Font("SansSerif", 0, 20))
jLabel4.setText("产品ID号")
jTextField2.setText("")
jTextField2.addActionListener(new Frame2_jTextField2_actionAdapter(this))
jPanel1.setLayout(xYLayout2)
jLabel5.setFont(new java.awt.Font("SansSerif", 0, 25))
jLabel5.setForeground(Color.red)
jLabel5.setText("该产品详细信息")
jTextField3.setText("")
contentPane.add(jLabel1, new XYConstraints(237, 0, 153, 40))
contentPane.add(jLabel2, new XYConstraints(200, 47, 231, 58))
contentPane.add(jLabel3, new XYConstraints(47, 102, 101, 42))
contentPane.add(jTextField1, new XYConstraints(128, 108, 112, 34))
contentPane.add(jTextField2, new XYConstraints(361, 107, 109, 36))
contentPane.add(jPanel1, new XYConstraints(75, 166, 453, 277))
jPanel1.add(jScrollPane1, new XYConstraints(14, 8, 433, 221))
jScrollPane1.getViewport().add(jTextField3, null)
jPanel1.add(jLabel5, new XYConstraints(112, 240, -1, -1))
contentPane.add(jLabel4, new XYConstraints(278, 111, -1, -1))
}
//Overridden so we can exit when window is closed
protected void processWindowEvent(WindowEvent e) {
super.processWindowEvent(e)
if (e.getID() == WindowEvent.WINDOW_CLOSING) {
System.exit(0)
}
}
void Select() {
try {
String str1, str2
str1 = jTextField1.getText()
str2 = jTextField2.getText()
^程^有偿解决此类问题,^序^
^设^如果您的要求与此类似,此回复有效.
^计^功能可定制,适应不同程度
^制^
^作^可 Baidu Hi / 私信/追问/求助联系,
补考管理系统
package com.company.daoimport java.sql.Connectionimport java.sql.DriverManagerimport java.sql.PreparedStatementimport java.sql.ResultSetimport java.sql.SQLExceptionimport java.sql.Statementpublic class BaseDao {
// 数据库驱动
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
//url
String url = "jdbc:sqlserver://数据库ip:端口号databaseName=数据库名"
//用户名
String uname = "数据库用户名"
//密码
String pwd = "数据库密码"
/**
* 获得连接对象
* @return
*/
protected Connection getCon(){
//返回的连接
Connection con = null
try {
//载入驱动
Class.forName(driver)
//得到连接
con = DriverManager.getConnection(url, uname, pwd)
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace()
} catch (SQLException e) {
e.printStackTrace()
}
return con
}
/**
* 关闭数据库
* @param con
* @param stmt
* @param rs
*/
protected void closeDB(Connection con, Statement stmt, ResultSet rs){
if(rs != null){
try {
//关闭结果集
rs.close()
rs = null
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
}
if(stmt != null){
try {
//关闭语句对象
stmt.close()
stmt = null
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace()
}
}
if(con != null){
try {
//关闭连接对象
con.close()
con = null
} catch (SQLException e) {
e.printStackTrace()
}
}
}
protected void closeDB(Connection con, PreparedStatement pstmt, ResultSet rs){
if(rs != null){
//关闭结果集
try {
rs.close()
rs = null
} catch (SQLException e) {
e.printStackTrace()
}
}
if(pstmt != null){
try {
pstmt.close()
pstmt = null
} catch (SQLException e) {
e.printStackTrace()
}
}
if(con != null){
try {
con.close()
con = null
} catch (SQLException e) {
e.printStackTrace()
}
}
}
这个是我写的一个基本的连接sql2005数据库的代码,.! 不知道你能不能用,! 你看一下吧, 连接的时候需要sqljdbc.jar数据库驱动,!
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)