【Java开源代码栏目提醒】:网学会员--在 Java开源代码编辑为广大网友搜集整理了:UsingDataSource1.java绩等信息,祝愿广大网友取得需要的信息,参考学习。
//UsingDataSource1.java
//author:ZhangHongbin
//This program is protected by copyright laws.
//Using DataSource to connect to a database.
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.net.*;
import java.util.*;
import javax.sql.* ;
import java.
sql.*;
import javax.naming.* ;
import com.
mysql.jdbc.jdbc2.optional.*;
public class UsingDataSource1 extends JFrame
{
Image myImage;
UsingDataSource1(String title)
{
super(title);
try
{
Hashtable env = new Hashtable() ;
env.put(Context.INITIAL_CONTEXT_FACTORY,
"com.sun.jndi.fscontext.RefFSContextFactory") ;
Context ctx = new InitialContext(env) ;
// lookup the JNDI name and returne DataSource object
DataSource ds = (DataSource)ctx.lookup("jdbc/mydb1") ;
//get a database connection from DataSource.
Connection con = ds.getConnection() ;
System.out.println("Connection Established.") ;
String selectSQL = "SELECT photo FROM imageTable1 WHERE NAME = ?" ;
PreparedStatement pstmt = con.prepareStatement(selectSQL) ;
pstmt.setString(1, "Zhang Hongbin");
ResultSet rs = pstmt.executeQuery() ;
rs.next() ;
Blob blob = rs.getBlob("photo") ;
Toolkit toolkit = Toolkit.getDefaultToolkit();
myImage=toolkit.createImage(blob.getBytes(1, (int)blob.length()));
rs.close();
pstmt.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void paint(Graphics g)
{
Font ft1=new Font("TimesRoman",Font.BOLD,25);
g.setFont(ft1);
g.drawString("The Beauty and The Beast",50,50);
g.drawImage(myImage,70,80,this);
}
public static void main(String[] args)
{
UsingDataSource1 win1 = new UsingDataSource1("UsingDataSource1");
win1.setSize(400,400);
win1.setVisible(true);
win1.addWindowListener(new CloseWindow());
}
}
class CloseWindow extends WindowAdapter
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
}