HI all
I am running an
applet in which i am connecting it with sql7.0. I made a permission from the jdbcodbc sriver. My applet runs very well but when i enter some data in the text box and i click on the button to let the data pass to the databasei get the following error:
java.security.AccessControlExveption: access denied(java.lang.RuntimePermission
accessClassPackage.sun.jdbc.odbc)
below is my code for the above:
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class Example extends JApplet
{
JPanel perPanel;
JLabel lblAppId;
JLabel lblAppName;
JLabel lblAppPosition;
JTextField txtAppId;
JTextField txtAppName;
JComboBox comAppPosition;
JButton butAccept;
GridBagLayout gl;
GridBagConstraints gbc;
public void init()
{
createAppletContent();
}
protected void createAppletContent()
{
FlowLayout flow;
flow=new FlowLayout();
Container content=getContentPane();
content.setLayout(new GridLayout());
JTabbedPane tabbedPane = new JTabbedPane();
content.add(tabbedPane,flow);
perPanel = new JPanel();
perDetail();
tabbedPane.addTab("Personal Details",null,perPanel,"Personal Detail");
}
public void perDetail()
{
gl = new GridBagLayout();
gbc = new GridBagConstraints();
perPanel.setLayout(gl);
lblAppId = new JLabel("Applicant Id");
lblAppName = new JLabel("Applicant Name");
lblAppPosition = new JLabel("Applicant Position");
butAccept = new JButton("Accept");
txtAppId = new JTextField(5);
txtAppName = new JTextField(20);
String positions[] = {"Manager","Sales Executive","Sales Manager"};
comAppPosition = new JComboBox(positions);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 1;
gbc.gridy = 5;
gl.setConstraints(lblAppId,gbc);
perPanel.add(lblAppId);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 4;
gbc.gridy = 5;
gl.setConstraints(txtAppId,gbc);
perPanel.add(txtAppId);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 1;
gbc.gridy = 8;
gl.setConstraints(lblAppName,gbc);
perPanel.add(lblAppName);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 4;
gbc.gridy = 8;
gl.setConstraints(txtAppName,gbc);
perPanel.add(txtAppName);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 1;
gbc.gridy = 11;
gl.setConstraints(lblAppPosition,gbc);
perPanel.add(lblAppPosition);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 4;
gbc.gridy = 11;
gl.setConstraints(comAppPosition,gbc);
perPanel.add(comAppPosition);
gbc.anchor = GridBagConstraints.NORTHWEST;
gbc.gridx = 3;
gbc.gridy = 20;
gl.setConstraints(butAccept,gbc);
perPanel.add(butAccept);
validateAction validateButton = new validateAction();
butAccept.addActionListener(validateButton);
}
class validateAction implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
Object obj = e.getSource();
if(obj == butAccept)
{
String appId = txtAppId.getText();
if (appId.length() == 0)
{
getAppletContext().showStatus("Applicant Id cannot be blank");
return;
}
String appName = txtAppName.getText();
if (appName.length() == 0)
{
getAppletContext().showStatus("Applicant Name cannot be blank");
return;
}
String position = String.valueOf(comAppPosition.getSelectedItem());
getAppletContext().showStatus(" ");
}
Object source = e.getSource();
if (source == butAccept)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con;
con = DriverManager.getConnection("jdbc
dbc:Example","sa","");
PreparedStatement stat=con.prepareStatement("insert into Example(cAppId,vAppName,vAppPosition)values(?,?,?)");
stat.setString(1,txtAppId.getText());
stat.setString(2,txtAppName.getText());
stat.setString(3,(String)comAppPosition.getSelectedItem());
stat.executeUpdate();
}
catch (Exception exception)
{
System.out.println("Error encountered while entering data in the database:"+ exception);
}
}
}
}
}
please reply soon
Thank You
Jitin.Rathod
[This message has been edited by Jitin Rathod (edited May 09, 2001).]
[This message has been edited by Jitin Rathod (edited May 09, 2001).]
[This message has been edited by Jitin Rathod (edited May 09, 2001).]
